Conditional Formatting

[ LiB ]

When you use conditional formatting, you can instruct Excel to change the formatting for a cell if the cell's value meets a certain criteria. For example, if the sales for a particular salesperson meets a quota, you could have Excel add blue shading and a border to the cell .

The second drop-down menu provides a list of operators such as greater than, less than, equal to, and between.

[ LiB ]