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?