Because I've got multiple ranges (financial report) with a series of
spaces and totals in between each "category" I've had to enter the
formula into each group manually as the "copy paste special
formats" or using the format painter doesn't help out as much because
of the $A$1 reference. Oh well...... it is a tedious job....