Use date to change font/shade/border

**FlashUK1983** · 02-06-2010, 09:42 AM

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** · 02-06-2010, 10:14 AM

Hi,

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

Code:

=$A$1=TODAY()
=A1-TODAY()<=7
=TODAY()-A1<=7

HTH

**FlashUK1983** · 02-06-2010, 10:39 AM

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.

Thread: Use date to change font/shade/border

Thread Tools

Display

Use date to change font/shade/border

Re: Use date to change font/shade/border

Re: Use date to change font/shade/border

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions