How do you use conditional formatting in Excel to highlight important patterns in data? Give examples of when it is useful for BI reporting.

Sample answer preview

Conditional formatting applies visual formatting to cells based on their values or conditions you define. It transforms raw numbers into a visual heat map that makes patterns, outliers, and exceptions immediately visible.