How to Use Conditional Formatting in Excel
- What is Conditional Formatting?
- How to Highlight Duplicates
- How to add Color Scales
- How to add Data Bars in Excel
- Highlight Overdue Dates
- How to add Icon Sets in Excel
- How to View and Edit Conditional Formatting Rules
- Rule Order Matters
- How to create an In-Cell Progress Bar
- How to Highlight Every Other Row
- Conditional Formatting Based on Another Cell
- How to create a Formula Rule
- How to Highlight an Entire Row
- How to Highlight Based on a Range
- How to Highlight Values NOT in a Range
- Create a Gantt Chart
- Use Data Bars to Compare Two Groups
- Control Scaling by Linking Min/Max to Cells
- Change Number Formatting with CF Rules
- Change Date Formats to d/m/yyyy
- Hide Zero Values
- Automatic Indenting
- Display 23K, 23M, 23B Based on Value
- Display Custom Icons
- How to Copy Conditional Formatting
- Conditional Formatting is Volatile
