Conditional Fromatting and Formulas

[Mark C via OfficeKB.com]

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

 

[damorrison]

Check out Format, Conditional Formatting in the menus

 

[Mark C via OfficeKB.com]

Check out Format, Conditional Formatting in the menus

I thied a few varations with conditional formatting. I tried the: greater
than, greatter that or equal to, and the between functions. It does not work
correctly with those for some reason

 

[damorrison]

I am not sure, is the value in the cell text??

 

[Mark C via OfficeKB.com]

I am not sure, is the value in the cell text??

The Text in the cell would be something like 1/16", 1/4", 5/8"

 

[Biff]

Hi!

Try this:

=LEFT(D5,FIND("/",D5)-1)/MID(SUBSTITUTE(D5,RIGHT(D5),""),FIND("/",D5)+1,255)>0.5

Biff