Ask Your Question

Revision history [back]

Calc: change whole row's background color matching specific strings

Apart from using Notepad++ to mark and then delete the rows from CSV file matching a string, Calc could be used by changing the background color of the whole row where a specific column's cells match strings. How do I do that ?

For example: a cell in column B contains string foo bar and every matching row's background should be colored the same.

Calc: change whole row's background color matching specific strings

Apart from using Notepad++ to mark and then delete the rows from CSV file matching a string, Calc could be used by changing the background color of the whole row where a specific column's cells match strings. How do I do that Possible ?

For example: a cell in column B contains string foo bar and every matching row's background should be colored the same.