IF Function with formatting condition

A

ABDIAZ

I need a formula that will do the following:
if the sum of j10/h10 is less than 50 then put the answer in red and bold.
Thanks in advance to anyone who can help me.
 
J

jennifer

You can use conditional formatting under the Format menu. Just select the
cell/cells where you have that formula then select where cell value is less
than or equal to 50 then select red as font or you can even choose a pattern
or fill for the cell. Good luck
 
Top