Hello,
I'm trying to highlight cells in column B following the condition that the sum of all cells in column B, for given item in column A, is less than the average in column C. I need to do this for all items in column A. I know how to do this using sumif and conditional formatting, but I'm trying to stay away from this as I want a user to manually un-highlight if they need to, which can be tedious with conditional formatting. So, I'm seeing if its possible with a macro.
Thank you!
Bookmarks