SOLVED
Home

excel formula cell colours

%3CLINGO-SUB%20id%3D%22lingo-sub-870405%22%20slang%3D%22en-US%22%3Eexcel%20formula%20cell%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870405%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i'm%20creating%20a%20risk%20register%20using%20cell%20formulas%20to%20give%20the%20risk%20rating%2C%20is%20it%20possible%20to%20also%20use%20the%20same%20formula%20string%20to%20colour%20the%20cell%20based%20on%20the%20risk%20rating%20result.%20The%20formula%20I%20am%20using%20is%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(N14%3D0%2C%22-%22%2CIF(N14%26lt%3B75%2C%22Acceptable%22%2CIF(N14%26lt%3B750%2C%22Controllable%22%2CIF(N14%26lt%3B7500%2C%22Undesirable%22%2C%22Intolerable%22))))%3C%2FP%3E%3CP%3EI%20would%20like%20the%20risk%20result%20cell%20to%20be%20coloured%20as%20%22Acceptable%22%20in%20Green.%20%22Controllable%22%20in%20Yellow.%20%22Undesirable%22%20in%20Red.%20%22Intolerable%22%20in%20Black.%20Any%20guidance%20would%20be%20great.%20-%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870515%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%20cell%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413639%22%20target%3D%22_blank%22%3E%40jp41867%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20conditional%20formatting%20to%20create%20the%20color%20scale.%20your%20settings%20will%20look%20something%20like%20in%20attached%20picture.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870623%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%20cell%20colours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870623%22%20slang%3D%22en-US%22%3EThanks%20loads%2C%20that%20works%20a%20treat%20and%20will%20save%20time%20colour%20coding%20risks!%20-%20brilliant%20help%20and%20much%20appreciated%20with%20the%20quick%20response%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
jp41867
New Contributor

Hi, i'm creating a risk register using cell formulas to give the risk rating, is it possible to also use the same formula string to colour the cell based on the risk rating result. The formula I am using is 

=IF(N14=0,"-",IF(N14<75,"Acceptable",IF(N14<750,"Controllable",IF(N14<7500,"Undesirable","Intolerable"))))

I would like the risk result cell to be coloured as "Acceptable" in Green. "Controllable" in Yellow. "Undesirable" in Red. "Intolerable" in Black. Any guidance would be great. - Thanks.

2 Replies
Solution

@jp41867 ,

You can use the conditional formatting to create the color scale. your settings will look something like in attached picture.  

Thanks loads, that works a treat and will save time colour coding risks! - brilliant help and much appreciated with the quick response
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies