What I am trying to do is put a conditional format on a cell that contains a
formula. The conditional format needs to be based on the result or the
formula.

Here is the formula that i am using it is in cell D5

=TEXT(ABS((C5-B5)*12),"0"&IF(ABS(((C5-B5)*12)-ROUND(((C5-B5)*12),0))1/32,"
0/"&CHOOSE(ROUND(MOD(((C5-B5)*12),1)*16,0),16,8,16,4,16,8,16,2,16,8,16,4,16, 8,
16),""))&""""

The conditional formattion that i was trying to apply is, if D5 is greatter
than 1/2" that it will change the color of the cell. Is there a way to do
that?

Your help is very appreciated

Mark


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1