conditional formatting based on another cell

bmuddy2

Active Member
Joined
Jun 22, 2004
Messages
398
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 ?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,400
Messages
5,831,413
Members
430,066
Latest member
rajd72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top