Excel - Verifying Data...

[WeaponX 0]

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.

[WeaponX 0]

Forgotto preview before I sent this one out. The above example should have the data aligned properly...my bad. You get the idea

[kaputnik 0]

Forgotto preview before I sent this one out.  The above example should have the data aligned properly...my bad.  You get the idea

1064324496[/snapback]

I have a complete spreadsheet tools e-book somewhere.. will hunt it down. Check your PM's for my private mail ID - send me your mailing ID so that I can e-mail you the spreadsheet e-book. you'll need to do a search through the e-book, but if what you're asking for is possible - then I do believe the e-book will be able to sort out your problems. Lemme start digging...

 

Rashid

[WeaponX 0]

Thanks kaputnik. Email sent...will be awaiting for the eBook.Hope it works...If anything, I will post the results here if I find out how to do it.