Conditional formatting: Less than, Greater than or "0".

D

Debbie

I have a workbook with multiple spreadsheets. I need my cells to have
conditional formatting. I have set up:
If less than 0: Font should be Red
If equal to 0: Font should be Black
If more than 0: Font should be Green

The less than and more than both work.
The equal to turns green.

How cab I make it turn black?

Thanks,

Debbie
 
P

PCLIVE

Your zeros are probably text instead of a number. Try putting quotes around
your zero ("0") in the conditional formatting and see if it changes.

HTH,
Paul
 
D

Debbie

I tried your suggestion.
I changed the format to "0".
When I looked back at the format it was changed to:
="'0'"
And the condition was still green instead of black as I need.

Debbie
 
P

Pete_UK

You could remove the middle condition, as CF takes precedent, so if
you have two conditions defined, one for greater than and another for
less than, then if the value is equal to zero the normal cell format
(set to black) will apply.

Hope this helps.

Pete
 
D

Debbie

Ok, now that I've wasted everyone's time...
I figured it out.
I have an "IF" statement that says if the cell is "0", enter a "0.00%".
I'm so sorry.
When I realized it, I was able to get my conditional formatting to work.

Thanks so much for all your help.

Debbie
 

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