| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting isnt working right
Condition 1 Cell value is Less than 0 then RED Condition 2 Cell value is Greater than or equal to 0 then Green this is what is in the conditional formatting boxes but for some reason when the value in the cell =0 the cell turns red instead of green. The value in the cell will always read a positive number because of in the individual cell formatting I have this written in the custom menu #,##,0.00;#,##,0.00 this conditional formatting works in other sheets but for some reason it doesnt work in this particular sheet. any ideas? Thks Ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
I am not sure, but since you filled out the conditionnal formatting form, why not change the cell formatting to "numbers" instead of "custom"? Doesn't cost to try (unless there is another reason to use custom...) -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
tried that but then the negative numbers in the cell get displayed and the font color goes red. I was doing it this way so the number would be displayed in positive but with the red cell fill color so the negative would be indicated by the red cell fill color. Ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
cell formatting has nothing to do with cell contents. You can format a cell
as "5" and it will always display 5 even if the value is -12. However, Excel will treat the value as -12, not as 5. So, your conditional formatting is not looking at the number format at all. If it's showing as RED, I'd guess the cell is REALLY <0. If that cell is E2, for example, put =E2<0 in another cell and you'll probably see TRUE. "changetires" wrote in message ... Condition 1 Cell value is Less than 0 then RED Condition 2 Cell value is Greater than or equal to 0 then Green this is what is in the conditional formatting boxes but for some reason when the value in the cell =0 the cell turns red instead of green. The value in the cell will always read a positive number because of in the individual cell formatting I have this written in the custom menu #,##,0.00;#,##,0.00 this conditional formatting works in other sheets but for some reason it doesnt work in this particular sheet. any ideas? Thks Ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
Ok I tried what you said Bob and it did indeed show "true", so that means the number isnt actually a true zero? Ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
Try increasing the decimal places and see if the 0 is 0.0000000000000123 or
similar. Is the "0" the result of a formula? Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP On Wed, 28 Jun 2006 10:19:58 -0500, changetires wrote: Ok I tried what you said Bob and it did indeed show "true", so that means the number isnt actually a true zero? Ed |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting isnt working right
When I increase the decimal figure to about 29 places my 0 actually reads -0.00000000001940314575678900000........ I tried putting this value in the conditional formatting tool but it will only work for one certain cell when I change cells so does this long number so the conditions are changing. I am almost ready to concede but not yet... tks, Ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=556505 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting Not Working Consistently | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
Hybrid Mode
