Video: Turn Conditional Formatting On or Off

In this video, I will share one of my favorite tricks in Excel. But I want to emphasize that even though I call this "a trick," it is extremely useful and helps with one of the most critical reporting areas - readability. This is a welcome addition to any Excel dashboard as it brings true value to the viewer.

Here is the link to the file I used in this video: https://excelolympics.com/wp-content/uploads/2022/03/Conditional-Formatting-OnOff1.xlsx

Links to blog posts and videos that are relevant: Excel Unplugged Blog Post (Turn CF On and Off): https://excelunplugged.com/2014/06/03/turn-conditional-formatting-on-and-off/ Simulating a Tabular Form Pivot Table Layout with CF: https://excelunplugged.com/2018/01/16/tabular-form-with-conditional-format/ Conditional Coloring of Sheet Tabs with VBA: https://excelunplugged.com/2018/02/20/conditional-coloring-of-excel-sheet-tabs-with-vba/ Highlighting Weekends with Conditional Formating: Video:https://youtu.be/GFVOI6yHwz8 Blog Post: https://excelunplugged.com/2018/02/20/conditional-coloring-of-excel-sheet-tabs-with-vba/

Chapters: 0:00​ Intro 0:08 Introduction to the video 0:51 Simple Example of Why You need the On/Off switch 1:41 Most Important part of Conditional Formatting 2:28 Building the Solution 4:51 Defining the New Conditional Formatting Rule 5:42 Bringing it all Together 6:21 Repeat of the Solution using a Data Validation DropDown 6:52 Creating the New Rule 8:19 Final Piece of the Puzzle 9:12 Conclusion 9:26 Outro

Gear Used:

US Links Camera: Canon EOS R6 - https://amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK Lights: Elgato Key Light - https://amzn.to/3rurte7

EU Links Camera: Canon EOS R6 - https://amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP Laptop: Dell XPS 15 - https://amzn.to/3effMmT Lights: Elgato Key Light - https://amzn.to/3vcs6v9 Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y

Recorded With: Camtasia - https://www.techsmith.com/video-editor.html

Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub

Subscribe to the Excel Olympics Newsletter: https://bit.ly/3w3rkjK

Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!

#Excel #ExcelOlympics #gasperkamensek