Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected

preview_player
Показать описание


Learn how to create a Logical Formula to color a table when a name is selected from a dropdown:
1. (00:13) Problem Overview
2. (00:35) Keyboard to jump between Excel Files: Ctrl + Tab
3. (00:53) Logic for how a formula can trigger conditional Formatting
4. (01:25) Keyboard short cut to open Conditional Formatting Dialog Box: Alt, H, L, N, Page Down, Tab. Keyboard from YouTuber Dale Holden.
5. (02:14) Logical Formula to color a table when name is selected.
6. (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 dropdown.
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:05:08

Excel Magic Trick 1230: Conditional Formatting: Highlight Table with Color When Name Selected

Excel Magic Trick 0:02:37

Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by C...

Excel Magic Trick 0:04:06

Excel Magic Trick 1228: Hours Worked Formula For Date & Time Values & Time Custom Number For...

Excel Magic Trick 0:06:47

Excel Magic Trick || Change color a Row in excel || Conditional formatting

Excel Magic Trick 0:14:21

Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?

Excel Magic Trick 0:04:08

Excel Magic Trick 1247: Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT

Advanced Excel Magic 0:16:04

Advanced Excel Magic Trick With SUMIF formula and Conditional Formatting

Excel Magic Trick 0:08:57

Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operations

Excel Magic Trick 0:11:27

Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers

Excel Magic Trick 0:08:46

Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Rang...

Excel Tips and 0:00:33

Excel Tips and Tricks - How to use CONDITIONAL FORMATTING

Show bottom 5 0:01:48

Show bottom 5 sale by excel conditional formatting

Excel Magic Trick 0:05:38

Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Functio...

Excel Magic Trick 0:03:56

Excel Magic Trick 1237: Add with 'Contains Criteria' or Partial Text Criteria: SUMIFS &...

Excel Magic Trick 0:03:35

Excel Magic Trick 1278: Extract Color From Description (Text String)

22 Dates with 0:03:01

22 Dates with IF & Conditional Format

Excel Magic Trick 0:08:42

Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1

Excel Magic Trick 0:05:15

Excel Magic Trick 1256: Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!!

Excel Magic Trick 0:10:45

Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

Excel Magic Trick 0:07:14

Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?

Excel Magic Trick 0:04:02

Excel Magic Trick 1239: Formula To Indicate a Date is in Leap Year

Excel 103 - 0:01:50

Excel 103 - 06 Conditional Formatting

Excel Conditional Formatting 0:00:47

Excel Conditional Formatting ➡️ Finding a Value

Excel Magic Trick 0:05:44

Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade ...

Комментарии
Автор

Great video, Thumb up!, After I learnt from this video I have managed to solve my highlight table formatting. Thanks a lot!!

sfalee
Автор

Thanks for the video and thanks to Dale for PgDn trick!

pmsocho
Автор

Thanks for another great video Mike. Minor thing. At 1:35 and 3:49 you said the shortcut keys correctly, but displayed on screen as alt H, L, H. 😄

krn
Автор

What are some useful uses for the example shown?

fmm
Автор

Simple conditional formatting avoids VBA! ...I gotta use 'Ctrl' 'Tab' more often.

MySpreadsheetLab