May 30 2021 03:07 AM - edited May 30 2021 05:30 AM
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?
May 30 2021 03:09 AM