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 ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://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
https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~