Conditional formatting is very useful feature available in excel which allow you to format a cell or range on the base to given condition.
Conditional formatting can be divided into 3 segments-Preset Rules, New Rules and Manage Rules. Below are the list of conditional formatting chapters-
Preset Rules-
- Chapter – 1: Highlight Cells Rules
- Chapter – 2: Top Bottom Rules
- Chapter – 3: Data Bars
- Chapter – 4: Color Scales
- Chapter – 5: Icon Sets
New Rules-
- Chapter-6: Format all cells based on their values
- Chapter-7: Format only cells that contain
- Chapter-8: Format only top or bottom ranked values
- Chapter-9: Format only values that are above or below average
- Chapter-10: Format only unique or duplicate values
- Chapter-11: Use a formula to determine which cells to format