I have conditionally formatted a worksheet with =$C6<=TODAY()-365, meaning that any lines with a date in Column C older than 1 year ago are filled with colour.

Is there any way of allowing me to hide all of the coloured rows EXCEPT the last one, so I can identify that there is archived data hidden (I know the row count will be 1,2,3,4,5,26,27,28,29).

So, I was thinking either:
Conditionally format but make the final line a different colour some way so that I could use Filter/Filter by Colour and hide Fill Colour 1, Do not hide Fill Colour 2 or No Fill
or
If there is any way of using any of the alternative filter options to not hide everything, just all of the lines except the final coloured one

There is no consistency between dates on differing tabs - it is for tracking absences from work - so would need to be a "one size fits all"