Complex conditional formatting copy does not work as expected

%3CLINGO-SUB%20id%3D%22lingo-sub-2398902%22%20slang%3D%22en-US%22%3EComplex%20conditional%20formatting%20copy%20does%20not%20work%20as%20expected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398902%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20the%20following%20conditional%20formatting%20involving%20a%20varaible%20group%20of%20cells%20(from%202%20to%2018%20cells)%3A%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3DIF(SUM(%24AE%241253%3A%24AE%241258)%3D1%2C1%2C0)%3C%2FP%3E%3CP%3EThe%20formatting%20puts%20in%20bold%20all%20cells%20content%20if%20the%20rule%20is%20matched.%3C%2FP%3E%3CP%3EIf%20I%20copy%20this%20format%20to%20another%20group%20of%20cells%20I%20have%20to%20modify%20manulaly%20the%20cell%20range.%3C%2FP%3E%3CP%3EIf%20I%20change%20the%20rule%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3DIF(SUM(%24AE1253%3A%24AE1258)%3D1%2C1%2C0)%3C%2FP%3E%3CP%3Ethen%20excel%20adjusts%20the%20cell%20range%20automatically%2C%20but%20then%20the%20conditional%20formatting%20randomly%20works%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2398902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2398917%22%20slang%3D%22en-US%22%3ERe%3A%20Complex%20conditional%20formatting%20copy%20does%20not%20work%20as%20expected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2398917%22%20slang%3D%22en-US%22%3EI%20forgot%20to%20add%20that%20I%20have%20300!%20sets%20to%20copy%20this%20formatting%20to...%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I have the following conditional formatting involving a varaible group of cells (from 2 to 18 cells):
     =IF(SUM($AE$1253:$AE$1258)=1,1,0)

The formatting puts in bold all cells content if the rule is matched.

If I copy this format to another group of cells I have to modify manulaly the cell range.

If I change the rule like this:

     =IF(SUM($AE1253:$AE1258)=1,1,0)

then excel adjusts the cell range automatically, but then the conditional formatting randomly works on the first or last few cells only.
Any idea on how to fast copy all format without manual editing of each set condition?

1 Reply
I forgot to add that I have 300! sets to copy this formatting to...