Paste Formatting is pasting in Hidden/Filtered Cells

[gpb237]

Hello, I've started a new job and the Excel settings here are different than the computer I used to have.

Before, I could filter a list and copy/paste formatting into all the cells in the filtered list. When I cleared the filter, normally the cells that were just filtered are the only ones that have the formatting I just pasted.

However, instead, when I clear the filter, every cell in that range has that formatting.

Any help with updating/changing the settings for this would be great.

Thanks!