Date & Conditional Format

[krishnanaik]

Please can some1 help

I am looking to conditional format a set of dates

i.e. colour cell blue if cells are 2 weeks or more before todays date
colour red if cells are 1 week or less todays date

I am after the formula I would put in the conditional format function.

HELP!!

Thanks

K

 

[Avatar]

take a look at this one to see if it helps:

http://www.mrexcel.com/board2/viewtopic.php?t=178313

EDIT: - no longer applies.. -> (it's three or four threads down from yours at this moment)

 

[krishnanaik]

That looks complex. Im sure there is an easier way of doing it.

Any ideas???

 

[Avatar]

well.. if you only want the number of days, such as 7 days or less etc then you could try

Condition 1: Greater than =TODAY()-7

Condition 2: Between =TODAY()-14 | =TODAY()-7

Condition 3: Less than =TODAY()-14

Just a thought..

 

[krishnanaik]

cheers pal