conditional formatting
It's not real clear what you want to do.
Do you want to highlight a cell in A4:Z4 or C3:C100?
A4:Z4 would contain 26 dates and C3:C100 would contain 98 dates. How can you
do a 1 to 1 comparison like that?
--
Biff
Microsoft Excel MVP
"Pete" wrote in message
...
I am trying to automate the colour of a cell depending on a date. In
cells A4:Z4 I have the weekending date starting at 08/01/2010 in A4,
then A4+7 in B4 then autofilling to Z4.
In cells C3:C100 I have the date I reviewed a Risk Assessment and
would like the cell that is closest to that date in A4:Z4 to
automatically colour "Red" to say that the next review is due that
week.
Can anyone help with this?
Thanks
Peter
|