View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rex Rex is offline
external usenet poster
 
Posts: 26
Default 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!