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


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

[damorrison]

Check out Format, Conditional Formatting in the menus

[Mark C via OfficeKB.com]

damorrison wrote:
> 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


--
Message posted via http://www.officekb.com

[damorrison]

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

[Mark C via OfficeKB.com]

damorrison wrote:
>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"


--
Message posted via http://www.officekb.com

[Biff]

Hi!

Try this:

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

Biff

"Mark C via OfficeKB.com" <u12467@uwe> wrote in message
news:565eadaae4af7@uwe...
> damorrison wrote:
>>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"
>
>
> --
> Message posted via http://www.officekb.com