Turning 0.000 values red

B

bz

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?
 
S

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
 
Top