Stel uw vraag

Mickledo's profiel - activiteit

2018-08-14 16:27:58 +0200 badge ontvangen  Beroemde vraag (bron)
2016-11-30 23:51:38 +0200 badge ontvangen  enthousiast
2016-11-29 22:18:05 +0200 beantwoorde een vraag Conditionally formatted cells do not work when I paste data into them.

Problem solved. In order to add say 10 extra rows to the top of my spreadsheet so that the current row 1 now becomes row 11 whilst retaining formats and conditional formats, you have to select in Paste Special: Subtract under Operations instead of Add. Selecting subtract in order to add data seems completely illogical to me; but hey ho, it works. Thanks for your responses calcUser and m.a.riosv.

2016-11-29 15:35:49 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-11-29 08:57:59 +0200 badge ontvangen  Populaire Vraag (bron)
2016-11-25 14:41:16 +0200 badge ontvangen  Redacteur (bron)
2016-11-25 14:17:46 +0200 stelde een vraag 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?