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

Your custom format works fine for me in my XL2003 (SP3) workbooks.

--
Rick (MVP - Excel)


"Neon520" <(E-Mail Removed)> wrote in message
news:F2B6DC17-1235-4729-B9EB-(E-Mail Removed)...
> 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

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

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