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 ?
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 ?