Copying Conditional Data Bar Format by Row to entire sheet

M

Moz

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top