Google Docs Spreadsheet has Conditional formatting which also know as Change Colors based on rules. To explain this feature let us take following sample data
Now in the above set of data, you can use Conditional Formatting to quickly highlight the values that match the following criteria
- Annual Premium greater than 1000
- Source is empty
- Dated before 10th March 2011
To add a rule for Annual Premium greater than 1000, Select the values under Annual Premium column, navigate to Format menu then select Conditional formatting from the menu list.
In the Change colors based on rules, select Greater than from drop down, enter 1000 in the value box and select the background to highlight the values that match this criteria
In the similar way, you can set the rules for Source column and Date column
The Cell values that match the specified criteria will be highlighted as shown below.
And if you want to Clear the formatting rules that have been added, then select rows/columns, click Format menu and select Clear formatting from the menu list.