Issue

How to highlight cells containing dates under Excel, using these parameters:

Previous days = Red

Current days = Yellow

Upcoming days = Green

Solution

Use conditional formatting

you have to enter three formula and choose color for each

=AND(A1<> "", a1 today()

Thanks to rizvisa1 for this tip.