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()
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
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
Answer 2 / 2
Baba
May 20, 2010 at 10:16 PM
***PROBLEM SOLVED***

THANK YOUR VERY MUCH "rizvisa1"

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses