How to highlight cells containing dates under Excel, using these parameters:
- Previous days = Red
- Current days = Yellow
- Upcoming days = Green
Use conditional formatting
you have to enter three formula and choose color for each
=AND(A1<> "", a1<today())
Thanks to rizvisa1 for this tip.