| | Hi, I have an Excel spreadsheet here that has 4 columns in it. The Date, some number, and whether it was received or not. I have the Not Received column highlighted in blue color. But what I want to do is that if there is an X marked in the column for Received, and the number matches to the one that's not received, I want the blue color to be changed to the default black again. As of now, I'm doing a lot of this manually. So, for example: Date Number Received Not Received 10/1/05 123 X 10/4/05 456 X 10/8/05 123 X So I want that blue X to be marked back to black once the entry for 10/8/05 (with the same number but marked Received this time). I tried doing an IF statement, but I don't know how to loop it through the whole list checking each Number in the column and also verifying that it's received. Thanks in advance. |
