TechTutorials

How to Highlight Rows Based on a Cell Value in Excel

Here’s how to highlight rows based on a cell value in Excel 2007 and Excel 2010. Reference this page for previous versions of Excel

  1. Select the table you want to apply the custom formatting to

[ExcelRowHighlight_Table

  1. Go to the Conditional Formatting ribbon option and select “New Rule”

[ExcelRowHighlight_ConditionalFormatting

  1. Format Setting
    Select “Use a formula to determine which cells to format” in the “Select a Rule Type” box Enter the INDIRECT function into the Rule Description Text Box

[INDIRECT method syntax: =INDIRECT("[COLUMN LETTER]"&ROW())=[VALUE]

Select a Format to Apply to the matching rows

Click OK

[ExcelRowHighlight_EditFormattingRule

  1. View the table and adjust the INDIRECT settings as required.

[ExcelRowHighlight_TableFormatted

HTH,

Jon