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