Answers
The option used to set up a second condition for the same selected cells.
Matches a cell only when its number is exactly the value being checked.
The cell or cells chosen before a condition is set, which can be a whole column.
A single test that decides which of the chosen cells should be formatted.
Seeing patterns in data more easily because the values that meet a condition stand out in colour.
Formats any cell that includes the given word, and is not case sensitive.
Changing the appearance of cells automatically when their contents meet the conditions we set.
A cell that matches none of the conditions set for it, so its appearance stays the same.
Giving each value in a column its own colour by setting a separate condition for each one.
The background colour given to a cell when it matches the condition set for it.
The drop-down menu where the type of condition to be checked is chosen.