Change colors based on rules in Google Spreadsheet

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.

In Category: Technical

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 3 Comments
  • kirilin August 9, 2013, 4:10 pm

    Hello, how i can add more than 10 conditional formats?

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.