Fields which change colour depending on % in other fields

Good Evening. I am looking for ways to do the following Have a field A2,3,4 etc, having a colour fill depending on the total % value in other fields. As a practical example please see the fo...

excel

Manicolo

Copper Contributor

Jul 12, 2022

Riny_van_Eekelen

I have been through your reply and it has been really helpful. However, one problem I am finding is if I want to copy and past that condition on multiple cells scattered around the worksheet.

Dragging the edge does not work, as it overrides the values inside the cell. Copying and pasting special is also not working for me as it keeps the original rule with the original reference field.

I am a bit stuck now.

I fear that this might not be understood easily. Let me suse your sheet as an example.

If you were to have 100 entries for A and E, how would you go about giving the column that condition?

Thanks