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?