Try Conditional Formatting.
"Clint" wrote in message
...
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,

--
Clint