Conditional formatting

Hi Christine

Thank you for your question. To make sure your conditional formatting behaves consistently select the cells which have your formatting applied to them and from the Home ribbon choose Conditional formatting > Manage rules. Click the active formatting rule and choose edit. Check the criteria Excel is using to trigger the conditional formatting. Many use a percentage of the total to drive the various formats and you may prefer to change the thresholds or switch from percentages to numbers.

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew