Overall Rag status (Red, Amber,Green)

[gift]

Hi all,

I have an excel with multiple sheets that have a single column where the user can have either Red, Amber or green as inputs.

I want to have one "color" in every sheet that gives the "overall" rating. the criteria for overall rating is providing the highest rating. So if there is a Red in that column , it should be the overall rating. if there is a Amber and green only, then Amber should be the overall rating, otherwise if there is green only, then green would be the overall rating.

See attached for example.

Thanks

 

[PCosta87]

Hi @gift

Please refer to attached.

There are many ways of achieving the desired result, this is just one of them.

Hope it helps

 

[gift]

Thanks so much. works perfectly.

 

[PCosta87]

Thanks so much. works perfectly.

You are welcome