close

I am using the following formula

=INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))

When the caculated value is 0.000 I want it to turn red. How can I do this?

use conditional formatting
--
Gary''s Studentquot;bzquot; wrote:

gt; I am using the following formula
gt;
gt; =INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))
gt;
gt; When the caculated value is 0.000 I want it to turn red. How can I do this?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄