Скачать с ютуб How To Highlight Rows Based On Dropdown List in Excel в хорошем качестве

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