conditional formatting
Formats data according to whether it meets a
condition (or where the product of a formula in other cells meets a specified
condition). Several different conditions can be set for a single cell. The
first true condition is applied.Whether a cell is editable can also be made
conditional.Conditions can be values or the products of formulas. You can use a
mix of value and formula conditions in a single cell.