Conditional Formatting isnt working right


C

changetires

Condition 1
Cell value is Less than 0 then RED
Condition 2
Cell value is Greater than or equal to 0 then Green


this is what is in the conditional formatting boxes but for some reaso
when the value in the cell =0 the cell turns red instead of green. Th
value in the cell will always read a positive number because of in th
individual cell formatting I have this written in the custom men
#,##,0.00;#,##,0.00

this conditional formatting works in other sheets but for some reaso
it doesnt work in this particular sheet.

any ideas?

Thks

E
 
Ad

Advertisements

T

Turquoise_dax

I am not sure, but since you filled out the conditionnal formattin
form, why not change the cell formatting to "numbers" instead o
"custom"? Doesn't cost to try (unless there is another reason to us
custom...
 
C

changetires

tried that but then the negative numbers in the cell get displayed an
the font color goes red. I was doing it this way so the number woul
be displayed in positive but with the red cell fill color so th
negative would be indicated by the red cell fill color.

E
 
B

Bob Umlas

cell formatting has nothing to do with cell contents. You can format a cell
as "5" and it will always display 5 even if the value is -12. However, Excel
will treat the value as -12, not as 5. So, your conditional formatting is
not looking at the number format at all. If it's showing as RED, I'd guess
the cell is REALLY <0.
If that cell is E2, for example, put =E2<0 in another cell and you'll
probably see TRUE.

"changetires" <[email protected]>
wrote in message
news:[email protected]
 
C

changetires

Ok I tried what you said Bob and it did indeed show "true", so tha
means the number isnt actually a true zero?

E
 
G

Gord Dibben

Try increasing the decimal places and see if the 0 is 0.0000000000000123 or
similar.

Is the "0" the result of a formula?


Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP
 
Ad

Advertisements

C

changetires

When I increase the decimal figure to about 29 places my 0 actually
reads
-0.00000000001940314575678900000........
I tried putting this value in the conditional formatting tool but it
will only work for one certain cell when I change cells so does this
long number so the conditions are changing. I am almost ready to
concede but not yet...

tks,

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top