| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting: Less than, Greater than or "0".
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
That didn't work either.
Any other suggestions? "PCLIVE" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 wrote: That didn't work either. Any other suggestions? "PCLIVE" wrote: 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- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting: Less than, Greater than or "0".
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting cells with formulas = "#VALUE!" | Excel Discussion (Misc queries) | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
| Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) | |||
| Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
| Conditional Formatting-can a "then" be placed with the "if". | Excel Worksheet Functions | |||
Linear Mode
