software

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 gt; conditional formatting, cell equal to 0, then click format
button and select a red pattern or a red font--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;bzquot; gt; wrote in message
...
gt;I have the following formula
gt; =INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))
gt;
gt; When I get a caculated value of 0.000 how can I make it turn red?
gt;
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
quot;typequot; field.

Hope this helps.

Sean
quot;bzquot; gt; wrote in message
...
gt;I have the following formula
gt; =INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))
gt;
gt; When I get a caculated value of 0.000 how can I make it turn red?
gt;