best performing branch in each region

Hi tay101 and welcome to the forum,

I think it would be pointless to give you any recommendations without seeing your data. I suggest that you upload a sample spreadsheet with about 10-15 rows of data so we could figure our a solution for you.

To upload a file click on Go Advanced on the bottom of your screen, then click on paperclip icon and Add Files.

There you go, there are stores in each region. How would I highlight the best

Please see attached file with stores highlighted on previous year data.

Hi again.

Just a quick note, forum rules suggest you wait at least 24 hours before "bumping" your thread.

Having said that, your use of merged cells make this a bit more complex than it needed to be. They way I tackled tghis was to add a helper column (J) and copied this down (you can hide this if you want to)
=IF(C7="",J6,C7)

Then, based on those cells, I used this ARRAY formula in K, copied down...
=IF(J7=J6,"",MAX(IF($J$7:$J$13=J7,$E$7:$E$13,0)))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

That was just a sample piece of data. I tried it and nothing highlighted. I did the separate helper column, then applied to formula in conditional formatting and no results. What cells should I highlight to apply the conditional formatting highlight?

And I don't understand what you did here

'=IF(C7="",J6,C7)

Then, based on those cells, I used this ARRAY formula in K, copied down...
=IF(J7=J6,"",MAX(IF($J$7:$J$13=J7,$E$7:$E$13,0))) '

Also, what should I do to make the merged cells better?

Seeing as there are 2 of us offering suggestions, it would help if you ID'd which of us your comment was aimed at LOL.

And I don't understand what you did here
'=IF(C7="",J6,C7)

All that is doing is pulling out the from the merged cells

And the rest...
=IF(J7=J6,"",MAX(IF($J$7:$J$13=J7,$E$7:$E$13,0)))
I used that to ID the highest store for each reagion. I put that in another helper, just to show the value. It could also have been used to Conditional Format the qualifying cells

See the attached for both ways

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.