Highlight Table Cell based on Dropdown Selection

Sharing data table with someone and wanting to quickly highlight a cell based on some dropdowns? This could be a situation where you’ve got a dashboard or report and you need users to find the main data point after they select something.
This video will show you how simple it is to create a dropdown. Not one but two! And once the choice is made, it’ll quickly highlight that part of a table to show the important information.
0:00 Intro
1:11 Create Dropdown List
1:52 Formula Combination
2:48 Detail Formula Explanation
4:40 Apply Conditional Format
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@wayneedmondson1065]

Nice trick Doug! Thanks and thumbs up!!

[@DougHExcel]

Wayne!! Thanks!

[@jeanpavan6816]

Like always, simple but highly efficient...and well explained

[@DougHExcel]

Hi Jean Pavan, thanks for the comment!

[@kenkenwelch]

Thank you. I was having trouble with this and the issue was with the $ relative stuff. Other tutorials focus on changing something in the row and I liked that this could be a separate dropdown list.

[@DougHExcel]

Glad it helped!

[@FRANKWHITE1996]

Thanks for sharing ❤

[@DougHExcel]

Thanks for watching!🙏🙏🙏

[@user-do3ic1ji8g]

This is great! How can I do this for multiple rows of information?

[@MrHardLiner]

Is that works from one to another linked data sheets in data validation?