formula for high lighting rows

  • Thread starter Thread starter Clint
  • Start date Start date
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,
 
Back
Top