Excel:Conditional Formatting Stops Working

Closed
Baba - May 23, 2010 at 07:42 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 25, 2010 at 06:18 PM
Hello,
First of all i am using 3 rules in conditional formatting and those are

=AND(c1<>"",c1<today())
RED

=c1=today()
Orange

=c1>today()
Green

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.
THANKS IN ADVANCE

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 24, 2010 at 05:54 AM
Hard to tell you without seeing the file.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
1
OK Thanks for reply here's the file
http://wikisend.com/download/461676/ACC.xlsx
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 25, 2010 at 06:18 PM
I dont have 2010, but your file is working on 2003, and 2007. When I opened the book, only A2:A41 was colored. Cell A3, A8, A12, A14, A35 and A41 were red,

try this for green
=AND(C1<>"", c1>today())

also what happens if in that green area you do type a value that should turn it to red or orange
0