Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Conditional Fromatting and Formulas
Check out Format, Conditional Formatting in the menus
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Conditional Fromatting and Formulas
I am not sure, is the value in the cell text??
|
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|