Shortcut keys
WindowsAlt → H → L
MacNo direct shortcut
Ribbon path
Home → Conditional Formatting
What it does
Apply color scales, data bars, or custom rules to highlight cells based on their values.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for conditional formatting?
On Windows, use Alt → H → L. On Mac, use No direct shortcut.
Where is conditional formatting in the Excel Ribbon?
The Ribbon path is Home → Conditional Formatting.
What does conditional formatting do in Excel?
Apply color scales, data bars, or custom rules to highlight cells based on their values.