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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for high lighting rows 1
Display weeks from a Milestone 0
PivotTable - Filter Row 0
On open goto today 2
If cell is blank automatically enter today's date in the same cell 21
Xlookup that returns variable sum data 3
Populate row with work days 2
Formula help 1

Top