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.