Turning 0.000 values red

[Guest]

I have the following formula
=INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))

When I get a caculated value of 0.000 how can I make it turn red?

 

[Peo Sjoblom]

Use format > conditional formatting, cell equal to 0, then click format
button and select a red pattern or a red font


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Sean]

Hi,

You can also try a custom number format like:
#,##0.00;-#,##0.00;[Red]#,##0.00
On the excel manu, select Format, Cells
On the Number tab, set category to Custom and place the string above in the
"type" field.

Hope this helps.

Sean