Hello,
I have a macro that highlights cells in column B based on the condition that the sum of cells in B > average in C.
This macro works great on sheet1. However, one sheet2 I have a little more information. I'd like the macro to treat each item (column A) differently.
I'm pretty sure I need another loop that determines where each unique item begins and ends in column A and determines the appropriate range to use in the existing loop.
Thank You for any help!
Bookmarks