Accelerate Conditional Formatting with the Quick Access Toolbar

- [Instructor] If you use conditional formatting a lot … you are no doubt familiar with the graphic … that we're seeing on the right side of the screen. … These are the same choices you see when you click … the conditional formatting button on the Home tab … up in the ribbon. … Now, if you've been working with Excel for a while … and are familiar with the ribbon menu system, … you know that any button here that you use frequently … on any of the different tabs can be available all the time … by adding it to what we call the quick access toolbar. … Typically, this sits above the menu, … although you have the option of putting it below as well. … So it's just a simple example before we talk about … conditional formatting here. … Suppose you use a feature on the View tab here … called Switch Windows. … This allows you to quickly see all open windows. … Now, you might or might not have others open … as you're using this but let's say rather than having to go … to the View tab all the time, simply right-click this, …