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?

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

software

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

E-mail轉寄