EXCEL - Help Setting Up Function to Determine Risk status based cell colour in a list

%3CLINGO-SUB%20id%3D%22lingo-sub-1520639%22%20slang%3D%22en-US%22%3EEXCEL%20-%20Help%20Setting%20Up%20Function%20to%20Determine%20Risk%20status%20based%20cell%20colour%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520639%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20set%20up%20a%20function%20in%20a%20cell%20to%20automatically%20determine%20a%20risk%20status%20based%20on%20colours%20stated%20in%20a%20list%20of%20cells.%3C%2FP%3E%3CP%3EColours%20would%20be%20Red%2C%20YellowRed%2C%20Yellow%20and%20Green%20in%20that%20order%20of%20severity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20-%3C%2FP%3E%3CP%3EIf%20in%20the%20list%20there%20are%20all%20green%20items%20the%20risk%20cell%20with%20the%20function%20should%20show%20green.%3C%2FP%3E%3CP%3EIf%20there%20are%20some%20green%20and%20some%20yellow%20items%20then%20the%20risk%20cell%20would%20show%20yellow.%3C%2FP%3E%3CP%3EIf%20there%20are%20some%20green%2C%20yellow%20and%20yellowred%20items%20then%20the%20risk%20cell%20would%20show%20yellowred.%3C%2FP%3E%3CP%3EIf%20there%20are%20some%20green%2C%20yellow%2C%20yellowred%20and%20red%20items%20then%20the%20risk%20cell%20would%20show%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20always%20only%20determine%20the%20worst%20case%20risk%20severity%20from%20the%20list%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20if%20someone%20could%20guide%20me%20as%20to%20how%20to%20do%20this%20if%20it%20is%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1520639%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello,

I would like to set up a function in a cell to automatically determine a risk status based on colours stated in a list of cells.

Colours would be Red, YellowRed, Yellow and Green in that order of severity.

 

Example -

If in the list there are all green items the risk cell with the function should show green.

If there are some green and some yellow items then the risk cell would show yellow.

If there are some green, yellow and yellowred items then the risk cell would show yellowred.

If there are some green, yellow, yellowred and red items then the risk cell would show red.

 

It would always only determine the worst case risk severity from the list selected.

 

Would appreciate if someone could guide me as to how to do this if it is possible.

 

Thanks

2 Replies
Highlighted
Highlighted

Hello, do you have any guidance as to how I could do this please?

 

Can it be done with a simple formula or with VBA code?

 

Thanks