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



"Cimjet" wrote:

Hi Debbie
In Conditional Formatting 0 and nothing is the same.
Regards
Cimjet
"PCLIVE" wrote in message
...
You might try change that condition to FormulaIs =INT(A1)=0

--

"Debbie" wrote in message
...
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


"PCLIVE" wrote:

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

--

"Debbie" wrote in message
...
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