I may have originally posted this in the wrong section of the site so I'm reposting. I'm trying to run a macro that helps me analyze monthly trend data. Ideally, the macro would highlight all cells where its respective absolute deviation is greater than the average deviation for its monthly trend(its row of data.) I already calculate the trend's average deviation for the monthly trend in a separate column and this formula has been copied down several rows. Any help is appreciated. I can post a sample spreadsheet if this wasn't clear. Thanks in advance!

Hi, grex. If your macro is already calculating the two values, then a) you can probably highlight the proper areas using ordinary conditional formatting, simply having Excel compare the two cells. But b) if your macro has already calculated both values, then maybe it'd be just as easy to highlight the proper areas within the macro, without conditional formatting. Depends on which you think is easier, I guess...and also on whether those calculated values might change later.

I take it you've already tried it one way or another and it isn't working. What did you try, and how did it fail? What error message did you get, for example?