conditional formatting

conditional formatting- it is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell.or the value of a formula.