Excel 2007 : Use date to change font/shade/border

[FlashUK1983]

I'm looking for a formula that will use the =IF(NOW()=DATEVALUE formula to check the current date and highlight a field if the current date is within 7 days of a date entered.

Example:
date entered = 12th.
If current date = 5th - 11th, then highlight = yellow
If current date = 12th, then highlight = green
if current date = 13th - 20th, then highlight = red

Is this even partly possible, and if so, how?

[Richard Buttrey]

Hi,

Three conditional formats, Green, Yellow and Red in this order using the 'formula' option rather than the cell value option.

Please Login or Register  to view this content.

HTH

[FlashUK1983]

Please excuse me. I'm fairly new to using formulas in Excell.

Could you explain this in a bit more detail for me?
I've pasted the code into a field, but that only called back a "false" response.