Conditional Formatting Excel Shortcut Key Explained

In Excel for Microsoft 365 on Windows, press Alt, then H, then L to open the Conditional Formatting menu; there is no single shortcut that automatically applies a chosen format. Select the cells first, then choose a rule from the menu.

The Windows shortcut and what it does

The key sequence Alt, H, L uses Excel’s ribbon KeyTips. Press the keys one after another rather than holding them all down at once: Alt displays KeyTips, H selects the Home tab, and L opens Conditional Formatting. From there, choose a rule such as Highlight Cells Rules, Top/Bottom Rules, Data Bars, Color Scales, or Icon Sets.

The shortcut opens the menu; it does not decide what counts as a match or choose a color for you. For example, to highlight values above a threshold, select the range, press Alt, H, L, point to Highlight Cells Rules, and choose Greater Than. Enter the threshold, pick a format, and confirm. The exact menu letters after opening the dropdown can depend on the displayed KeyTips, so use the letters shown on your screen or navigate the menu with the arrow keys.

If the KeyTips do not appear as expected, use the ribbon path Home > Conditional Formatting. That path is also a dependable way to confirm that you are in the right menu when ribbon customization or a different Excel build changes the available KeyTips.

Apply a rule from the ribbon

Conditional formatting changes how cells look when their values meet conditions. It does not replace or edit the underlying values. A cell may display a red fill because it meets a rule, while the stored number remains unchanged and can still be used in calculations.

A straightforward workflow is:

Select the cells you want the rule to affect. Selecting the range first helps Excel set the rule’s target correctly.
Open Home > Conditional Formatting, either with the Alt, H, L key sequence or by clicking the ribbon command.
Choose a built-in rule category and specify the condition, or choose New Rule for more control.
Choose the formatting, such as a fill color, font color, or border, and confirm the dialog.
Check the result against several cells, including values near the condition’s boundary.

For instance, select B2:B30 and use Highlight Cells Rules > Greater Than to flag sales figures above 1,000. The rule evaluates each cell in the selected range and applies the selected appearance to the values that meet the condition. If the range later grows, edit the rule’s Applies to range so the new rows are included.

What the built-in rule categories do

The built-in choices cover common comparisons without requiring a formula. Highlight Cells Rules can flag values greater than, less than, equal to, or between specified numbers, as well as text containing a phrase, dates in a chosen period, and duplicate or unique values. The exact options available depend on the rule type.

Top/Bottom Rules identify high or low values, including items above or below an average. Data Bars add bars inside cells to show relative magnitude; Color Scales shade cells along a color gradient; and Icon Sets show symbols such as arrows or traffic-light-style indicators. These visual treatments are useful for scanning a report, but they do not change the sort order or calculate a ranking for you.

Choose the display according to the question the worksheet should answer. A single highlight is usually clearer for a yes-or-no threshold, while a color scale can help compare many values. Data bars work well when readers need to compare sizes while keeping the numbers visible. Avoid adding several competing colors and icons to the same small table: too many visual signals can make the important exceptions harder to spot.

Use a formula for a custom condition

A formula-based rule is useful when a built-in comparison cannot express the condition, or when formatting one cell depends on another. To create one, select the cells to format and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter a formula that returns TRUE for cells that should receive the format, choose the format, and confirm.

For example, suppose each row has a product name in column A and a sales amount in column B, with records in rows 2 through 20. To shade each entire row when its sales amount is over 1,000, select A2:D20 before creating the rule. Use this formula:

=$B2>1000

The dollar sign fixes the column at B, while the row number remains relative so Excel checks the sales value on each row. The rule formats a row when its column B value exceeds 1,000. A value of 1,250 in B2 makes the first selected row qualify; a value of exactly 1,000 does not, because the condition is greater than, not greater than or equal to.

For a duplicate check, suppose the values to examine are in A2:A100 and that range is selected. A formula rule can use:

=COUNTIF($A$2:$A$100,A2)>1

This counts how often the current cell’s value appears in the full range and formats it when the count is greater than one. Blank cells may also need special handling in a real list, depending on the intended result. Formula rules depend on the selected range and reference style, so check that the first row in the formula corresponds to the first row of the Applies to range.

Relative references and rule targets

Reference behavior is a frequent source of surprises. In a formula rule, Excel normally interprets relative references from the upper-left cell of the range being formatted, then adjusts them for other cells. Use dollar signs deliberately: $B2 keeps the column fixed but lets the row change; B$2 lets the column change but keeps row 2 fixed; and $B$2 locks both.

If a rule highlights the wrong rows, check two things before rewriting the formula. First, confirm that the formula is written for the first cell in the Applies to range. Second, confirm that its references are locked in the direction the rule needs. For a whole-row highlight based on a value in column B, the column usually needs to be fixed so every cell in that row checks the same sales value.

Manage, edit, and prioritize rules

To review existing rules, use Home > Conditional Formatting > Manage Rules. In the Rules Manager, check the selected range shown in Applies to, edit a condition, change its formatting, or remove a rule that is no longer needed. If you do not see the rule you expect, change the display scope in the manager, such as viewing rules for the current selection or the worksheet.

When multiple rules apply to the same cells, their order can affect the appearance. The Rules Manager lets you change rule priority; a rule higher in the list is evaluated earlier. Some rules can also have a Stop If True option, which prevents lower-priority rules from being applied to a cell when that rule is true. Use it only when that blocking behavior is intended. Conflicting fills or font colors can otherwise make the final result confusing.

It is worth reviewing the rules after copying or expanding a worksheet. Pasted cells may bring formatting or rules with them, and similar-looking rules can accumulate. Manage Rules can help identify duplicate rules and ranges that accidentally overlap. Keeping a small, purposeful set of rules makes a workbook easier to maintain and less likely to display misleading signals.

Excel for Mac and Excel for the web

On a Mac, the ribbon command is available at Home > Conditional Formatting, but the Windows Alt, H, L KeyTip sequence is not the Mac equivalent. Use the ribbon with the mouse or the Mac’s available keyboard navigation rather than assuming the Windows sequence will work. Menu and dialog details can vary by Excel release, so the visible ribbon labels are the safest guide.

Excel for the web also provides conditional-formatting controls from the Home tab, though its interface and keyboard behavior are not identical to desktop Excel for Windows. If a workbook is being edited in a browser, use the displayed ribbon commands and check that the rule is supported in the web version. For advanced editing or a complex formula-based rule, opening the workbook in the desktop app may provide more complete controls.

Common problems and practical checks

Nothing happens after the shortcut: Press Alt, H, and L in sequence, and make sure Excel is active rather than a cell editor or another application.
The wrong cells are colored: Inspect the Applies to range and the formula’s relative and absolute references.
A value that looks like a number is not flagged: Check whether it is stored as text, and verify that the threshold and comparison operator are correct.
New rows are not formatted: Extend the Applies to range or create the rule for a range that includes the rows you expect to use.
A color seems inconsistent: Look for other rules on the same cells and review their order and Stop If True settings.

One common misconception is that conditional formatting is a permanent change to cell contents. It is not: deleting a rule removes the visual treatment, not the value. Another is that a data bar or color scale changes the underlying number; these are visual cues only. If color conveys essential meaning, consider adding a text label or another accessible indicator so the information is not communicated by color alone.

Frequently Asked Questions

Is there a one-key shortcut for Conditional Formatting in Excel?
No. In Excel for Microsoft 365 on Windows, Alt, H, L is a sequential ribbon shortcut that opens the Conditional Formatting menu. You still choose the rule and its settings.

How do I open Conditional Formatting without a mouse?
On Windows, press Alt, then H, then L to open the menu, and use the visible KeyTips or arrow keys to reach a command. You can also use Excel’s ribbon keyboard navigation, but the precise key sequence after opening the menu depends on the displayed KeyTips.

Can I apply conditional formatting to an entire row?
Yes. Select the rows or table area, create a formula-based rule that checks the relevant column, and use a fixed column reference with a relative row reference when appropriate. Confirm that the formula matches the first row of the selected Applies to range.

Does conditional formatting change the cell value?
No. It changes the cell’s appearance when a condition is met. The underlying value remains available for formulas, sorting, and other worksheet operations.

Why is the shortcut different on my Mac?
Alt, H, L is a Windows ribbon KeyTip sequence, not a universal Excel shortcut. On Mac, use Home > Conditional Formatting on the ribbon; keyboard options and interface details vary by release.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.