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.
- Select the rows
- Select from the Home tab the Conditional Formatting tool.
- From the list that drops down Select New Rule…
- Type the following formula in the dialog box.
Where E is the column name where your condition lies, and Canada is your condition.