Re: Conditional formatting: Less than, Greater than or "0".
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Wed, 5 Mar 2008 12:34:31 -0800 (PST)
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
On Mar 5, 8:22 pm, Debbie <Deb...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
That didn't work either.
Any other suggestions?
"PCLIVE" wrote:
You might try change that condition to FormulaIs =INT(A1)=0
--
"Debbie" <Deb...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B48F73D1-765A-4881-A311-A410B1C1F4FC@xxxxxxxxxxxxxxxx
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" <Deb...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1E399F0-E3B8-4E1C-B923-CC096388C86B@xxxxxxxxxxxxxxxx
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- Hide quoted text -
- Show quoted text -
.
- References:
- Prev by Date: Re: formatting help
- Next by Date: UDF from Add-In returning #NAME
- Previous by thread: Re: Conditional formatting: Less than, Greater than or "0".
- Next by thread: Re: Conditional formatting: Less than, Greater than or "0".
- Index(es):
Relevant Pages
|
