if, then formula with conditional formating
IF(D4<=(E4*4),"OK","NOT OK")
D4 E4
182 41
this returns NOT OK (41*4 = 164) 182 is not <=164
Can I write this as a conditional formating formula? Return the answer
(164) but change the font color it if it does not meet the OK criteria.
Thanks in advance!
I'm learning a lot reading this discussion group!
|