Conditional Formatting (Red Is Older Than Today)Nov 27, 2009
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.