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.
|