Vba loop help for cumulative addition

[DevLord007]

Hi,

I require help in doing the following, attaching a file for info.


1) Loop needs to start from D2, Add values of B2 and C2, check if D2 value is more than average of sum of B2 and C2, if more highlight in red
2) Loop need to continue at E2 where it needs to add values of B2,C2,D2 and check average, if more highlight in red
3) Loop need to stop before grand total in row

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...92-vba-loop-help-for-cumulative-addition.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.