Highlight rows based on current cell value and changes when moving to other cell

Ps: Prefer NON VBA solution if possible

I know I can do this

Select 'Use a formula to determine which cells to format'.
Enter the formula =$E5="UK"

But what I want is, when the Cursor moves to row $E$7 and the text in there is different, then all the other rows (with the same text in Column $E as in $E$7) should be highlighted instead of the ones that have the text from $E$5.

Ps: I prefer NOT to use VBA for this WB, so I have no idea if it is possible this way.
I could do it with a Helper cell, but would prefer not to do that as the data is already present in the column (starting from $E5)


Edit: Sorry forgot, please give me a hint first instead of the full solution. Thx

Any conditional formatting that depends on what cell is currently selected is going to require VBA.

thought as much, shame.

This is a WB which (when finished) I am giving to my friends and I don't want them to have to mess with VBA code.

Changing a formula oke, but messing with VBA no.

Thx again, appreciated.

Is there another way? (again without VBA?)

edit: Oke just for my curiosity what would the VBA code be?

Here is a demo solution. There is a lag from when you select the row to when the rows are highlighted. I am not sure why that is. But it shows the functionality. Click in any row to highlight all the rows with that country.

Thx really appreciated.

Shame indeed that it is not possible without VBA, but I am really surprised how little code it needs.

I found something which will work for now, but not using Conditional Formatting.

I just put a filter on "Country". Oke you don't get "fancy" line fills, but for my friends (and me) this will do!

That's a good solution. It didn't occur to me to suggest that because that's not the same thing you asked for, but whatever works.