formula for high lighting rows

[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,

 

[Corey ....]

Try Conditional Formatting.