Would it be acceptable to add a filter along with the highlight action? That would give you just the one value and highlight it, but not sure if it causes other issues for you.
i see you are ranking so filtwring would alter that, if you are using a Table Calc. Providing a TWBX along with mocked up expected results is ideal on this forum whenever possible - you can either sample your own data and randomize in excel or use one of the data sources that ship with Desktop.
I do not know of any way to achieve an auto scroll with a highlight action but there may be alternate approaches that provide the same end result. If, for example, you could calculate the rank in the database a filter would not impact the rank as it does wit’s a table calc.