Previous Topic Next Topic

Excel:Conditional Formatting Stops Working

Closed
Baba - 23 May 2010 à 19:42
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 May 2010 à 18:18
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
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 May 2010 à 05:54
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.
Baba1
25 May 2010 à 18:08
OK Thanks for reply here's the file
http://wikisend.com/download/461676/ACC.xlsx
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
25 May 2010 à 18:18
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses