Hello,
I'm trying to write a macro that highlights cells where the sum of the cells are greater than the average of cells in a different column.
For example on the attached sheet, if A1 > avg B1:B10, highlight. If not, is A1 + A2 > avg B1:B10,, and so on until the condition is met.
Thank You
Bookmarks