PlayInfoBox

Home /Utilities /How to Highlight an Entire Row with a Conditional Formatting Formula in Excel

How to Highlight an Entire Row with a Conditional Formatting Formula in Excel

Tap each step to see how to highlight a whole row with conditional formatting.

  1. Select the full table range to highlight

    Select the entire range of the table where you want matching rows highlighted.

  2. Click Conditional Formatting β†’ New Rule

    On the Home tab, click Conditional Formatting, then New Rule.

  3. Choose "Use a formula to determine which cells to format"

    In the rule type list, select the option that lets you enter a formula directly.

  4. Enter a formula with "$" only before the column

    For example, typing =$C1="Done" β€” with the dollar sign only in front of the column letter β€” applies the formatting to the whole row whenever the condition is true.

  5. Why it helps

    When you want to emphasize an entire row instead of just one cell based on a column's value, combining absolute and relative references lets you automatically color every matching row.

Tired of only one cell changing color?

If only the cell showing "Done" changes color, it's easy to miss at a glance. Mixing absolute and relative references in your formula highlights the whole row instead, making matching records far easier to spot in a long list.

Combine multiple conditions with AND or OR

You aren't limited to a single condition β€” wrapping your comparisons inside AND() or OR() in the same formula lets you highlight rows that meet two or more conditions at once, such as a status column and a due-date column together.

Frequently Asked Questions

Why does the dollar sign only go in front of the column letter?

Locking only the column keeps that column fixed as the reference while the row number changes for each row in the selected range, so every row is checked against the same column.

Can I apply more than one condition at a time?

Yes. Nesting AND or OR inside your formula lets you highlight rows only when two or more conditions are true at the same time.