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 |