vendredi 7 octobre 2016

Conditional Formatting based on if(sum<>0)-statement

I've got a lot of if(sum)-Statements in my worksheet and would like to know if it is possible to give a condtional formatting based on my if-statement.

For example the if functions are looking like this:

=IF(SUM(I24:I960;I965:I1065;I1067;I1069;I1071;I1073;I1075;I1077;I1079:I1129;I1131:I1240;I1242;I1244;I1246;I1248;I1250;I1252;I1253:I2046)<>0;1;0)

and I would like to color the elements red, which makes the Statement "true".

I already did this manually by copying the cell areas in the conditional formatting, but it seems like Excel has restrictions concerning the space of the formular. Because of this problem, I have to start all over again every time this happens. Thats why I'm asking you for help. Maybe you can give me some insight on this.

Best Regards

Aucun commentaire:

Enregistrer un commentaire