customize number format/Display Text color

[Jon_P]

trying to i have a collum of numbers totaled. the total amount is checked against the actual numbers example 100 200 300 400 500 = 1500 (total, comes from weekly estimate) in cell I30 and the actual amount (actual comes from actual dial reading) is 1500 in cell B10. what i want to do is if the I30-B10= 0 I want the text color to be GREEN, If the amount is negative i want the text color to be RED and if the amount is postive I want the text color to be yellow.
1500-1500 = 0 display 0 is 1500-1400= 100 display 100 or if 1500-1600= -100 display -100

and i would like hole numbers no decimals...

[JosephP]

[yellow]0;[red]-0;[green]0
oughta work

[Jon_P]

I have tried this 0 displays yellow...

[JosephP]

if it shows yellow, it's not 0 (you just can't see the decimal places). you could use:
round(I30-B10,0)

[Jon_P]

would it look like this?

[Yellow]0;[Red]-0;[Green]0;round(I30-B10,0)

[JosephP]

no-the formula goes in the cell not in the number format.

[Jon_P]

thank you...

[Jon_P]

it worked thanks a ton..