Formula that returns a hi-lighted row

C

Clint

I would like to look into a cell and return a high lighted row.

if todays date is less than 5 days prior the date in the cell, high light
the row green

if todays date is between 5 and 0 days prior the date in the cell, high
light the row amber

if todays date is 0 days prior or greater the date in the cell, high light
the row red

Can anyone help?

Thanks,
 
D

David Biddulph

Format/ Conditional Formatting/ Formula Is:
=TODAY()<$A1-5 format as green,
=TODAY()<$A1 format as amber
=ISNUMBER($A1) format as red
 
Top