I have a spreadsheet that runs sls results by month (column) by Cust (Row).
I set up a data bar to reflect activity based on average of the 3 most recent
months. The only way I have found to copy the format to the last 3 months of
each row is to select the 3 months of sls and double click the format painter
and then select each individual row. If I try to select multiple rows the
data bars change the average to the entire selection instead of just the last
3 months by row. What am I missing here?