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:
Publicar un comentario