Conditional formatting enables you to highlight (or "format") cells according to the value appearing in them, by specifying a certain rule. You can set the cell's color, backgrounds, fonts, set the whole row format, copy the rules and use formulas within them.