Help with formula/ conditional formatting

[19thelakes82]

Hello

Please see enclosed.

I wish for my cells to colour based on a percentage of the value.
If a number is 55% or more to the total then colour
If a number is 45% or more to the total then colour
If not either of the above leave plan - can this work?

Thank you in advance

[maniacb]

Use this formula for the >55%

Please Login or Register  to view this content.

Use this formula for the >45%

Please Login or Register  to view this content.