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

2) Go to the Conditional Formatting ribbon option and select “New Rule”

3) 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

4) View the table and adjust the INDIRECT settings as required.

HTH,

Jon

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS