| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting Problem
Hello, I am running office 2003.
I have a conditioinal format that says if cell is less than 0 to turn the cell red. I have cells that are red and they have a value of 0. they are NOT less than zero yet they are still turning red. The adjacent cells have formulas. when I take out the formula and just type in the number the conditional formatting works correctly. What would cause this? It is not happening on all cells. it si sporadic... Any insight would be greatly appreciated!! Thanks again... Myssie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Problem
Is it possible you have a round off? The cell might hold -0.00000000000009
but display 0 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "myssieh" wrote in message ... Hello, I am running office 2003. I have a conditioinal format that says if cell is less than 0 to turn the cell red. I have cells that are red and they have a value of 0. they are NOT less than zero yet they are still turning red. The adjacent cells have formulas. when I take out the formula and just type in the number the conditional formatting works correctly. What would cause this? It is not happening on all cells. it si sporadic... Any insight would be greatly appreciated!! Thanks again... Myssie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Problem
That is the problem... there is a .05. The cell is being rounded up. How
can I get excel to ignore these and only look at the value of the cell rounded up. "Bernard Liengme" wrote: Is it possible you have a round off? The cell might hold -0.00000000000009 but display 0 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "myssieh" wrote in message ... Hello, I am running office 2003. I have a conditioinal format that says if cell is less than 0 to turn the cell red. I have cells that are red and they have a value of 0. they are NOT less than zero yet they are still turning red. The adjacent cells have formulas. when I take out the formula and just type in the number the conditional formatting works correctly. What would cause this? It is not happening on all cells. it si sporadic... Any insight would be greatly appreciated!! Thanks again... Myssie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Problem
Either use the ROUND function in your cell formula, or include the ROUND
function in your CF formula. -- David Biddulph "myssieh" wrote in message ... That is the problem... there is a .05. The cell is being rounded up. How can I get excel to ignore these and only look at the value of the cell rounded up. "Bernard Liengme" wrote: Is it possible you have a round off? The cell might hold -0.00000000000009 but display 0 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "myssieh" wrote in message ... Hello, I am running office 2003. I have a conditioinal format that says if cell is less than 0 to turn the cell red. I have cells that are red and they have a value of 0. they are NOT less than zero yet they are still turning red. The adjacent cells have formulas. when I take out the formula and just type in the number the conditional formatting works correctly. What would cause this? It is not happening on all cells. it si sporadic... Any insight would be greatly appreciated!! Thanks again... Myssie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting problem | Excel Discussion (Misc queries) | |||
| Problem with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting problem | Excel Worksheet Functions | |||
| conditional formatting problem | Excel Discussion (Misc queries) | |||
| Problem with conditional formatting | Excel Worksheet Functions | |||
Linear Mode
