View Single Post
  #2   Report Post  
jennifer
 
Posts: n/a
Default

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.