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?

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


"bz" wrote in message
...
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?

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



"bz" wrote in message
...
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?