Scroll enabled to minimise table view...but need conditional formatting

[Excelwhatsthat]

Hi Experts,

I'm a competent novice (but definitely not a whizz)...and created a scroll bar on a basic dashboard table to show 10 rows of a 30 row table. I have added conditional formatting to highlight the highest value in column 2 (each column is year). Problem is, however, it's only highlighting the highest valued cell based on the VISIBLE numbers in column 1 only (i.e. 10 rows). So when you scroll up/down, the highlighted cell changes! How do I set up the conditional formatting to highlight only the highest number in the full column of data? (image provided...where I've removed the conditional formatting):

table hosted at ImgBB

I did consider just a static highlight of the cell with the highest number, but this gets messed up as I have a slicer filter on years.

Thanks so much.

Jams