Apologies that was my mistake. The formula should have read:
=$F2=SUBTOTAL(5,$F:$F)
Apply this formula as instructed before with all the data selected and
A2 as the activecell.

Regards
Rowan

craigproudfoot wrote:
It still only highlights the single cell - what relevance is A2 i'm not
sure i understand that one.