Highlight cells based on sum > value in another column - loop

[phbryan]

Hello,

Im trying to write a macro to take care of highlighting cells in column E based on the following:
For each unique value in column D, if the sum of cells in column F are greater than the values in column W (average or first value), highlight E.
For column F, the macro needs to check if the first value is greater. If not, continue to the next value and add to the last value and check if it is greater again. When the sum is greater, highlight the corresponding cells in E. Continue for all unique values in column D.

Attached is an example workbook, with one sheet pre-highlighted to help illustrate my thinking. Also, a jpeg showing the logic.

This sheet has about 100 rows, but my actual sheet contains about 2000.

Thank you for any help!

[JeteMc]

I believe that what you want could be done using a conditional formatting formula.
1. Select cells E2:E102
2. Paste the following into the Format values where this formula is true window:

Please Login or Register  to view this content.

Let us know if you have any questions.