Forum Discussion

Copper Contributor

Jul 10, 2022

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

Riny_van_Eekelen

Platinum Contributor

Jul 11, 2022

Manicolo That's done with Conditional Formatting. You can learn more about that in the link below.

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

The attached file contains a working example of what could work for you, assuming that 15% and 50% are the relevant boundaries for the colour change.

manicolo.xlsx9 KB

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

Riny_van_Eekelen
Platinum Contributor
Jul 12, 2022
Manicolo Look into changing the "applied to" range. If you get stuck, please share a file via OneDrive, GoogleDocs or something similar.