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.
Published by deri58
Latest update on January 24, 2013 at 12:32 PM by deri58.