I'm trying to prepare a code in vba for excel. For each month there is a list of values, each month is listed in a separate column, multiple values are listed below each month.
What I wanted to do is change the color of each cell which value is 4 times smaller than the month's average. So far my code looks like this, each average is calculated like I wanted it, but i can't seem to figure out how to get it to compare the cells only to one column's average, not to all of them consecutively - like it does now.
Bookmarks