Conditional Formatting - Highlight Rows with the Top 3 Risks

[LYoung33]

I am building a template risk register and in addition to the conditional formatting I have for High, Medium, Low I would now like the sheet to be able to highlight the TOP 3 risks within the sheet based on the values in column G.

This is an example of how the template looks currently:

And this is how I would like it to pull out the top 3 risks based on the values in column G... top 3 highest values to be highlighted in yellow like so (ideally not going over the RAG colour already in column G)

Thank you in advance!

 

[SanjayGMusafir]

I think this should work. Check this and revert -

Use below to conditional Format the whole range -

=OR($G1=Large($G:$G,1),$G1=Large($G:$G,2),$G1=Large($G:$G,3))

 

[LYoung33]

I think this should work. Check this and revert -

Use below to conditional Format the whole range -

=OR($G1=Large($G:$G,1),$G1=Large($G:$G,2),$G1=Large($G:$G,3))

It worked! Thank you so much

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.