Just add new rule, select the range A4:C100, open conditional formatting, add new rule, select to use formula, and the formula to format is:
=sum(H4:Q4)<0, and the color to format is obviously, grey

I couldn't get that formula to work so that they would all stay grey if H4:Q4<0, so I turned it around and made it so they would be no-fill if H4:Q4>0. This worked for the most part (I just auto-filled all the cells grey so that they would change to no-fill when data was entered), except for columns H, I and J. When data is entered into column H, only column A changes; when data is entered into column I, only column B changes; for column J, only C changes. Any suggestions on how to make the first formula work or fix the problems with columns H, I and J?

in the sample atached, A to C column will turm grey if =SUM($H12:$Q12)<0, this means that these columns will not turn grey if you have, say, 25 in H12, and -20 in Q12, because the sum is positive. If you want A to C to turn grey at any negative value in H12: Q12, you have to say that clearly, dont let me guess. The formula for this case is: =OR(H12<0;I12<0;J12<0;K12<0;L12<0;M12<0;N12<0;O12< 0;P12<0;Q12<0)

Attached Files

Copie a sample2-conditional formatting.xlsm (19.7 KB, 18 views)