Cumulative Conditional Formatting based on Sum

[compd1]

Hi All,

I am hoping someone could assist. I am after conditional formatting to highlight values based on a cumulative total upto 80% as per the attached spread sheet. I have given all the required information on the spread sheet.

Appreciate any assistance or guidance.

Thanks,

Compd1

[Harribone]

The attached should be what you want. I've made a helper column after the Cumulative Total whih checks if the total is less than 80% (0.80) and returns "x".
The conditional formatting aplied highlights yellow if the helper cell to the right is "x" OR if the helper cell to the right and one up is "x" so that the 80% target met is highlighted yellow.

This helper colum can be hidden to keep your work tidy if you want. Let me know if you need help more of an explanation on anything i've done.


Cumulative Conditional Formatting.xlsx

[compd1]

Great, thank you. Works well.

[Kevin UK]

Hi compd1

Select the the cells you wished to apply the formatting in column D, then new rule under conditional formatting.
For the rule:

Please Login or Register  to view this content.

[compd1]

Awesome.

Thanks.