Treat a coloured cell as a %value for use in a formula

Question

I would like to colour a cell green, orange or red to represent 100%, 50% or 0% respectively so that i can use it in a formul, ie if the cell is orange a formula uses the cell as 50% etc.

Any help gratefully accepted

brian

jkpieterse · Answer

Hi Brian,I advise to do the opposite: Enter the percentage into the cell and use a conditional format to have Excel color the cell. Excel is bad at doing calculations based on formatting.

nikolinode · Answer

brian999&nbsp;&nbsp;Use conditional formatting to highlight informationhttps://support.microsoft.com/en-us/office/ways-to-count-values-in-a-worksheet-81335b1b-d5e8-4f42-ae72-245b948c45bd&nbsp;NikolinoIch weis das ich nichts weis (Sokrates)

Forum Discussion

Treat a coloured cell as a %value for use in a formula

2 Replies

Use conditional formatting to highlight information

Resources