Conditional Fromatting and Formulas
 

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

Conditional Fromatting and Formulas
 

Check out Format, Conditional Formatting in the menus

Conditional Fromatting and Formulas
 

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

Conditional Fromatting and Formulas
 

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

Conditional Fromatting and Formulas
 

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

Conditional Fromatting and Formulas
 

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