Apply conditional formatting in Google Sheets after pasting

In Google Sheets, you encounter a problem when pasting data into a conditional formatting cell: it's style is lost.

To solve it, just design your conditional formatting attached to another cell (EG. For cells A1:F10 apply red background when =$B1<0), and create a filter. Sort by that column (B) and the conditional  formatting for all the range is refreshed properly.

No hay comentarios: