Conditionally formatted cells do not work when I paste data into them.

I have conditional formatting set up to colour the cell backgrounds of credit payments in my bank statements.
When I download my latest bank statements (CSV) and paste the data into my spreadsheet (paste special) the new positive cells do not get conditionally formatted and I end up having to manually colour the cells using the clone formatting paintbrush to achieve the desired effect or reapplying conditional formatting to the whole column.
Does anyone know where I’m going wrong please?

How do you open your CSV file?

Did you use Paste special->Numbers?

Any chance you are in Design mode? not sure if that can cause this but it might. also, I would review the “paste special” dialog closely for clues, maybe just try regular paste…

Be sure,you are pasting numbers not numbers as text.

Hi guys, I’ve been looking around and I think this is a small bug.

I’ve noticed that when I have a multi-row and multi-column range in conditional formatting, whenever I copy-paste cells within this range, the conditional formatting range is broken up. It does not break anything, but is very messy when you want to edit the conditional formatting.

I think your problem is related to this. When you paste a formula from a cell without conditional formatting, or with a different type of conditional formatting, the formatting comes with the cell, so the original range is broken up.

I can reproduce this behavior reliably in version

There is Menu/Edit/Paste special [Ctrl+Shift+V] to paste without the format.