Previous Topic Next Topic

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

Answer 1 / 2
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()
2
Baba
May 23, 2010 at 07:44 PM
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 24, 2010 at 05:55 AM
see your other question
https://ccm.net/forum/affich-356510-excel-conditional-formatting-stops-working
0
Answer 2 / 2
Baba
May 20, 2010 at 10:16 PM
***PROBLEM SOLVED***

THANK YOUR VERY MUCH "rizvisa1"
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses