IF Function with formatting condition
 

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.

Thanks so much, it worked great. I think I was over-thinking it.

"jennifer" wrote:

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

"ABDIAZ" wrote:

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.

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

"ABDIAZ" wrote:

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.