0

I'm trying to apply conditional formatting to a few hundred rows of data, but I want to keep them separate. Meaning, if I want to color cells based on their proximity to the average value, I want that average value to only be computed using data in its particular row. While my data-set was small, I was simply using the format painter as Microsoft suggests (as does one of several answers to this related question). Now that I have hundreds of rows, however, I can not manually copy the formatting to each individual row especially because the "clipboard" resets each time.

As Dave J. mentions, the only solution to this problem might be to use a macro. Is this true? What can I do?

2
  • Could you show some text data and expected output? Jun 16, 2016 at 19:37
  • Have you tried updating the Applies To section in the Conditional Formatting Rules Manager?
    – B540Glenn
    Jun 16, 2016 at 19:53

1 Answer 1

0

You could paste (the formatting) into multiple rows at once, but it is easier to simply put all rows in the Applies-to field

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .