Highlighting dates conditional formating

Solved/Closed
Baba - May 20, 2010 at 08:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 24, 2010 at 05:55 AM
Hello,

How to highlight dates in "EXCEL" i mean

Less than Today = RED
Today = YELLOW
Greater than Today = Green


Please help me i've been trying this for more than 2 months but couldn't find it

Thanks in advance

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 20, 2010 at 08:44 PM
use conditional formatting

you have to enter three formula and choose color for each

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


=a1=today()


= a1> today()
it works perfectly but when i save it and close the excel program and then open it again all the cells become green i tried my best to find the problem but no luck please help me I'll really appreciate it i cant even send this file to anyone because when they open it the conditions don't work all the cells becomes green....
I'm using office 2010 blue edition by the way
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 24, 2010 at 05:55 AM
***PROBLEM SOLVED***

THANK YOUR VERY MUCH "rizvisa1"

Similar discussions