How to highlight rows based on drop down list in Excel

• -- By Sumit Bansal

Watch Video – Highlight Rows based on Cell Values in Excel

In case you prefer reading written instruction instead, below is the tutorial.

Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it.

But sometimes, insteadof just getting thecell highlighted, you may want to highlight the entire row (or column) based on the value in one cell.

To give you an example, below I have a dataset where I have highlighted all the rows where the name of the Sales Rep is Bob.

In this tutorial, I will show you how to highlight rows based on a cell value using conditional formatting using different criteria.

Click here to download the Example file and follow along.

Color/Conditional Formatting Drop-down List in Excel:

In this article, we are going to learn how to Color/Conditional Formatting Drop-down List in Excel 365 using Kutools. Colored Drop-Down List feature of Kutools will handle this task in an easy and quick way.

How do I highlight rows in Excel with a drop-down list?

Select Row of data range option from the Apply to section; Then, select the drop down list cells and data range you want to highlight the rows; At last, specify the color for the drop down list items separately as you need.

How do I change the color of a row in Excel based on dropdown selection?

On the Home tab of the ribbon, click Conditional Formatting > Manage Rules… Select ‘Use a formula to determine which cells to format’. Here, 2 is the row number of the active cell and K is the column containing the dropdown menus. Activate the Fill tab and specify the desired color.

How to Apply Conditional Formatting to Rows Based on Cell Value

Bottom Line: Learn to change the formatting of an entire row of data based on the value of one of the cells found in that row.

Skill Level: Intermediate