Cell colours according to date
I have formulas set up to have in cell a1 Mon 01/01/07 as a date, in the rest
of the cells I have =a1+1 and so on to fill in all dates for the year, what I
need is for cells that only contain Sat and Sun in the date to change colour
to yellow, is this possible, I have tried through CF but not formatting as
the cells contain formulas
Regards
MN
|