Conditional Formatting can make a Spreadsheet more relevant (Image CRedit Rosenhammer
Conditional Formatting can make a Spreadsheet more relevant

Many of us use conditional formatting which changes the colour of a cell where a calculation result sits. This is to easily identify items that meet certain criteria we set. Sometimes you may require to change the entire row of a list not just one cell. To do this, follow these instructions.

Open the list you need to colour.formatting row 1

  • Select the rows
  • Select from the Home tab the Conditional Formatting tool.formatting row 2
  • From the list that drops down Select New Rule…formatting row 3
  • From the Select a Rule Type: choose Use a formula to determine which cells to formatformatting row 4
  • Type the following formula in the dialog box.

=indirect(”E”&ROW())=”Canada”formatting row 5

Where E is the column name where your condition lies, and Canada is your condition.

  • Now select the Format… button formatting row 6in this dialog box to choose the colour you require.formatting row 7

On selecting OK twice your spreadsheet immediately is formatted. Here is what it can look like.formatting row 8

The beauty of having conditional Formatting Rules is that you can revisit them and edit them at will or add to the list of conditions.formatting row 9

Resulting in formatting row 10

You can also sort by colour of cells.formatting row 11


Please enter your comment!
Please enter your name here