Conditional Formatting

**charger100** · 11-27-2009, 07:39 AM

C2 Cell formatted for Date

Currently is shows red if its older than today showing something has expired using: Cell Value is less than =TODAY() and shows Green if it still OK using greater to or equal to =TODAY()

But i want:

Red is older than today
Amber is today or within 7 days
Green if date is over 7 days

Ive tried using 'between' but keep getting white cells..... Thanks

**arthurbr** · 11-27-2009, 07:47 AM

Hi, you have the possibility of using three conditions. When you have entered the first, click the "add" button, enter second condition, etc..

**charger100** · 11-27-2009, 07:54 AM

Hi - yes there are two conditions already for the red and green, but the 3rd condition for the amber i cant seem to get right....

**rwgrietveld** · 11-27-2009, 08:39 AM

=AND(C2>=(TODAY()-7),C2<Today())

**charger100** · 11-27-2009, 09:10 AM

Right - im doing something wrong....

Cell Value Is Less Than =TODAY() (this is formatted Red)
plus
Formula Is =AND(C2>=(TODAY()-7),C2<TODAY()) (this is formatted amber)
plus
Formula Is =AND(C2>(TODAY()-8)) (this is formatted Green)

However the cells are remaining today and older in red and tomorrow and onwards in Green... no amber....