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!