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.


Be the first to comment

Leave a Reply