conditional formatting based on another cell

[bmuddy2]

in column A i have starting with cell A1 the dates for the year.
in column B i have a formula that looks at todays date and checks column A for the same date and if they match it reads "yes" if they dont match it reads "".

so if todays date is 7-21-10 and in cell A626 the cell contains 7-21-10 then in cell B626 it will read "yes".

Now my question is i want to use conditional formatting in columns C,D,E,F, and G and have it look at the result in column B. I would like for C626,D626,E626,F626 and G626 to highlight yellow if cell B626 reads "yes". The next day (7-22-10) would be "yes" in cell B627 and cells C627,D6278,E627,F627 and G627 to highlight yellow.

any ideas ?

 

[SteveO59L]

Use the "Formula Is " option in Conditional Formatting

 

[VoG]

This should help http://www.contextures.com/xlCondFormat02.html

 

[bmuddy2]

thanks for the help.