Hi,

I currently manage conditional formatting of cells that require a reasonably complex formula by placing a formula in a cell, then have the conditional formatting formula point to that cell.

My question is:

Am I sacrificing efficiency and speed by defining additional formulas in the sheet rather than configuring the formula in the conditional formatting dialogue?

For example, I have this formula in cell AG190.

=AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18))

or more precisely, this formula is filled across cells AG190:AO190

Elsewhere, I have a range of cells with conditional formatting that simply refer to these cells i.e.

=AG$190

so using this example, my question is 

would my sheet be more (or less) efficient/faster/slower if I placed the formula in the conditional formatting rule? i.e. change the =AG$190 to =AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18)) and just forget about using the interim calculation cells?

TIA

RedNectar

​Hi,I currently manage conditional formatting of cells that require a reasonably complex formula by placing a formula in a cell, then have the conditional formatting formula point to that cell.My question is:Am I sacrificing efficiency and speed by defining additional formulas in the sheet rather than configuring the formula in the conditional formatting dialogue?For example, I have this formula in cell AG190.=AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18))or more precisely, this formula is filled across cells AG190:AO190Elsewhere, I have a range of cells with conditional formatting that simply refer to these cells i.e.=AG$190so using this example, my question is would my sheet be more (or less) efficient/faster/slower if I placed the formula in the conditional formatting rule? i.e. change the =AG$190 to =AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18)) and just forget about using the interim calculation cells?TIARedNectar  Read More

​