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)