Hi,
I'm hoping to get some help with a lookup formula.
I have in Sheet1, contract numbers in column A that I need t lookup in Sheet2, for each Colum B to E in sheet1, if the corresponding Column in Sheet2 is conditionally formatted Green, then "Yes" on Sheet1 needs to be written and if Sheet2 is formatted RED, then "NO" needs to be written in Sheet1.
I have attached a sample worksheet for reference.
Looking forward to your assistance and thank you in advance!
Last edited by Dannypak; 09-13-2010 at 06:07 PM.
You can't test the color of a conditional format with a formula. You can, though, apply the same test as the CF that leads to the color.
Since you're obviously using Excel 2007, try this in B3, copy across and down
see attached
Please Login or Register to view this content.
Last edited by teylyn; 09-13-2010 at 10:44 PM.
Hi,Originally Posted by teylyn
You can't test the color of a conditional format with a formula. You can, though, apply the same test as the CF that leads to the color.
Since you're obviously using Excel 2007, try this in B3, copy across and down
see attachedPlease Login or Register to view this content.
Thank you very much for you advice, searching for "Opt-in" & "Opt-out" is a great solution.
I am having some trouble with the formula though...it's doesn't seem to be able to correctly search/index/match. I'm getting blanks all the way...
I attached a new sample workbook for you to take a look if you can...
Thanks again so much for your help!
dan
Start in F3 with
copy across.Please Login or Register to view this content.
That's awesome!
You are amazing!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks