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

%3CLINGO-SUB%20id%3D%22lingo-sub-1573016%22%20slang%3D%22en-US%22%3ETreat%20a%20coloured%20cell%20as%20a%20%25value%20for%20use%20in%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573016%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20colour%20a%20cell%20green%2C%20orange%20or%20red%20to%20represent%20100%25%2C%2050%25%20or%200%25%20respectively%20so%20that%20i%20can%20use%20it%20in%20a%20formul%2C%20ie%20if%20the%20cell%20is%20orange%20a%20formula%20uses%20the%20cell%20as%2050%25%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20gratefully%20accepted%3C%2FP%3E%3CP%3Ebrian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573016%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573042%22%20slang%3D%22en-US%22%3ERe%3A%20Treat%20a%20coloured%20cell%20as%20a%20%25value%20for%20use%20in%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573042%22%20slang%3D%22en-US%22%3EHi%20Brian%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20advise%20to%20do%20the%20opposite%3A%20Enter%20the%20percentage%20into%20the%20cell%20and%20use%20a%20conditional%20format%20to%20have%20Excel%20color%20the%20cell.%20Excel%20is%20bad%20at%20doing%20calculations%20based%20on%20formatting.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

2 Replies
Highlighted
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.
Highlighted

@brian999 

 

Use conditional formatting to highlight information

https://support.microsoft.com/en-us/office/ways-to-count-values-in-a-worksheet-81335b1b-d5e8-4f42-ae...

 

Nikolino
Ich weis das ich nichts weis (Sokrates)