WeaponX 0 Report post Posted October 1, 2005 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. Share this post Link to post Share on other sites
WeaponX 0 Report post Posted October 1, 2005 Forgotto preview before I sent this one out. The above example should have the data aligned properly...my bad. You get the idea Share this post Link to post Share on other sites
kaputnik 0 Report post Posted October 3, 2005 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 Share this post Link to post Share on other sites
WeaponX 0 Report post Posted October 4, 2005 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. Share this post Link to post Share on other sites