Conditional Formatting

Highlight Cells Rules  |  Clear Rules  |  Top/Bottom Rules

Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. the following are some conditions by which a user can effectively manage his data.

1. Highlight Cells Rules
2. Color Scales
3. Manage Rules
4. Conflicting Rules
5. Shade Alternate Rows
6. New Rule
7. Data Bars
8. Checklist
9. Compare Two Lists
10. Find Duplicates
11. Icon Sets