Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
Hi everyone,
As you can see in the subject line that I would like to custom my cell formatting so that if the number is greater than zero, it's BLACK if the number is less than zero, it's RED and if it's zero, it's BLUE I have a problem with the BLUE one, for some reason, when there is a deduction in which the result is ZERO, Excel recognize it as LESS than zero, and it shows in RED instead of BLUE. But in normal case without and deduction, the above Custom Formatting works just fine. Any tips you want to share about this? Thanks alot! Neon520 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
Your custom format works fine for me in my XL2003 (SP3) workbooks.
-- Rick (MVP - Excel) "Neon520" wrote in message ... Hi everyone, As you can see in the subject line that I would like to custom my cell formatting so that if the number is greater than zero, it's BLACK if the number is less than zero, it's RED and if it's zero, it's BLUE I have a problem with the BLUE one, for some reason, when there is a deduction in which the result is ZERO, Excel recognize it as LESS than zero, and it shows in RED instead of BLUE. But in normal case without and deduction, the above Custom Formatting works just fine. Any tips you want to share about this? Thanks alot! Neon520 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
Both -0.000001 and 0.000001 will display as 0.00 but neither are zero. You probably need to round the cell value. -- Jim Cone Portland, Oregon USA "Neon520" wrote in message Hi everyone, As you can see in the subject line that I would like to custom my cell formatting so that if the number is greater than zero, it's BLACK if the number is less than zero, it's RED and if it's zero, it's BLUE I have a problem with the BLUE one, for some reason, when there is a deduction in which the result is ZERO, Excel recognize it as LESS than zero, and it shows in RED instead of BLUE. But in normal case without and deduction, the above Custom Formatting works just fine. Any tips you want to share about this? Thanks alot! Neon520 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT)
Or use a custom number format similar to this...
[Black][0.001]$#,##0.00;[Red][<-0.001]($#,##0.00);[Blue]$0.00;[Green]"(CHECK DATA)" -- Jim Cone Portland, Oregon USA "Jim Cone" wrote in message Both -0.000001 and 0.000001 will display as 0.00 but neither are zero. You probably need to round the cell value. -- Jim Cone Portland, Oregon USA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some row numbers blue some black, why? | Excel Discussion (Misc queries) | |||
How do I change the color to blue, silver,or black | Excel Discussion (Misc queries) | |||
Blue and black arrows in Filters | Excel Discussion (Misc queries) | |||
Why do some filename's appear blue instead of black? | New Users to Excel | |||
why are some file names blue and some are black | Excel Discussion (Misc queries) |