How To Highlight Rows Based On Dropdown List in Excel
How To Highlight Rows Based On Dropdown List
In a previous tutorial I’ve explained How to Highlight Rows Based on Specific Text in Excel : • How To Highlight Rows Based On Specif...
In this excel tutorial I’ll use the same procedure but the highlighting will be based on dropdown list. I’ve an employee list of 500 names, email, job title and department. I’m creating a system where, from a dropdown I select a department name and all the employee details of that department will be highlighted.
I’ve created a lot of tutorials on Dropdown list in excel that’s why I’m omitting that in this tutorial. Please check the following videos and learn how to create different dropdown list in excel:
How to Create a Drop-Down List in Excel Using Data Validation: • How to Create a Drop-Down List in Exc...
How to Create Drop down Lists in Excel Using Named Ranges: • How to Create Drop down Lists in Exce...
How to Create Dependent Drop Down List in Excel: • How to Create Dependent Drop Down Lis...
How to Update Items in Drop down List Automatically in Excel: • How to Update Items in Drop down List...
How to Create a Dynamic Searchable Drop Down List in Excel: • How to Create a Dynamic Searchable Dr...
The Quickest Way To Create Dynamic Drop Down List In Excel: • The Quickest Way To Create Dynamic Dr...
I think, now you know all about dropdown list in excel. Its time to learn how to highlight rows based on dropdown list in excel. Follow the steps and it’ll take only a minute.
Step 1: Create the dropdown list.
Step 2: Select the data range you need to highlight.
Step 3: Click on “conditional formatting” and then “new rule”
Step 4: Click on “Select formula to specify which cells to format”
Step 5: Now write the first cell no. of the column where you need to match your data then write = (Equal to) and then the cell number where you have your Dropdown list.
Step 6: Click on format and select the highlight color from there and click Ok Twice.
Done. This is how we change of a row color based on a dropdown list in another cell.
Notes:
In step 5 you need to write the cell number of the column where you need to check specific text will have to write in this format $E2 not $E$2 or E2. All you need to remember is that $E means the column number is fixed, it will not change. And the row number here will change and check if any cell has the text, you specified in the dropdown and then take action.
#HighlightRows #Excel #ConditionalFormatting
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Смотрите видео How To Highlight Rows Based On Dropdown List in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 03 Сентябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42,151 раз и оно понравилось 202 людям.