Excel Magic Trick 1230


Conditional Formatting: Highlight Table with Colour When Name Selected
Learn how to create a Logical Formula to colour a table when a name is selected from a drop down:
(00:13) Problem Overview
(00:35) Keyboard to jump between Excel Files: Ctrl + Tab
(00:53) Logic for how a formula can trigger conditional Formatting
(01:25) Keyboard short cut to open Conditional Formatting Dialog Box: Alt, H, L, N, Page Down, Tab. Keyboard from YouTuber Dale Holden.
(02:14) Logical Formula to colour a table when name is selected.
(04:15) If you have three conditions, you only need two logical formulas. The default formatting will appear when the third name is selected from the drop down.