Conditions not me but conditional formatting still takes effect

[joemc911]

Here's what I am doing. I have a cell using a percentage base of 0-100. I don't display it in percentage, but that's the number range. I have conditionally formatted the cell as follows: Condition 1 if = 100 color cell green, condition 2 is between 1 and 99 color cell yellow, condition 3 if = 0 color cell red. It works wonderfully except that if there is no data and the cell is blank it still colors it red as though it was = to 0. I use other formatting to show absences with these cells so I don't want it disturbed unless I actually enter data. So, as you see, I am perplexed. I don't know what to do to make it stop the formatting of the cell. According to the Excel help it "shouldn't" apply any formatting to the cell, but it does..

I appreciate any help anyone can provide. If possible, please also e-mail the reply as I am not sure how often I can revisit the thread to check on answers to it. Thank you!

 

[Andy B]

Hi

Try Formula is with =AND(A2=0,A2<>"")
It worked for me!!

--
Andy.

Here's what I am doing. I have a cell using a percentage base of 0-100.

I don't display it in percentage, but that's the number range. I have
conditionally formatted the cell as follows: Condition 1 if = 100 color cell
green, condition 2 is between 1 and 99 color cell yellow, condition 3 if = 0
color cell red. It works wonderfully except that if there is no data and
the cell is blank it still colors it red as though it was = to 0. I use
other formatting to show absences with these cells so I don't want it
disturbed unless I actually enter data. So, as you see, I am perplexed. I
don't know what to do to make it stop the formatting of the cell. According
to the Excel help it "shouldn't" apply any formatting to the cell, but it
does...

I appreciate any help anyone can provide. If possible, please also e-mail

the reply as I am not sure how often I can revisit the thread to check on
answers to it. Thank you!

 

[Frank Kabel]

Hi
for the last condition use the formula
=(A1=0)*(A1<>"")

--
Regards
Frank Kabel
Frankfurt, Germany

Here's what I am doing. I have a cell using a percentage base of

0-100. I don't display it in percentage, but that's the number range.
I have conditionally formatted the cell as follows: Condition 1 if =
100 color cell green, condition 2 is between 1 and 99 color cell
yellow, condition 3 if = 0 color cell red. It works wonderfully except
that if there is no data and the cell is blank it still colors it red
as though it was = to 0. I use other formatting to show absences with
these cells so I don't want it disturbed unless I actually enter data.
So, as you see, I am perplexed. I don't know what to do to make it
stop the formatting of the cell. According to the Excel help it
"shouldn't" apply any formatting to the cell, but it does...

I appreciate any help anyone can provide. If possible, please also

e-mail the reply as I am not sure how often I can revisit the thread to
check on answers to it. Thank you!