What is the purpose of conditional formatting?

• A. Share rows/columns from another Cube View
• B. Provide the ability to format headers or cells based on defined criteria
• C. Determine if users want to display gridlines within Excel
• D. Format the workbook tabs

Answer: (B)

Conditional formatting applies formatting to cells automatically when their values meet defined rules. This makes important data stand out and patterns or exceptions easy to spot without manually inspecting every value. You can set rules that change background color, font, borders, or add color scales and icons, and these rules can apply to both data cells and headers to reflect the same criteria. This directly captures the purpose of conditional formatting: formatting headers or cells based on defined criteria. It’s not about sharing rows or columns from another Cube View, nor about toggling gridlines or formatting workbook tabs.