Conditional Formatting

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

Manage Rules-

• Chapter-12: Manage and Clear Rules

Download the Excel file for practice