See screenshot: Note: It’s optional to check the Apply view to subfolders option as you need.So far the conditional formatting has been copied from the currently selected folder, and pasted into folders you checked in above Step 3.Not only does it make your spreadsheet look awesome, it also enables you to make sense of your data and spot important cues in the blink of an eye.
So in this quick tutorial I will show you hoe to:1 ~ Sum rather than Count;2 ~ Fixed Number Formats;3 ~ Automatic Refresh! This usually happens when you download data from your ERP or external system and it throws in numbers that are formatted as text e.g. Sometimes you will need to locate the Pivot Table that has the Grouped values.
For example I have added a conditional Formatting in Inbox folder to show all emails from a certain sender in big red font in the Mail List as below screenshot shown.
But when I copy these special emails to others folders, the conditional formatting are lost.
Throughout these 15 tips to conditional formatting, we’ll be using a sample file.
This sample file has been created specifically for this guide, so we highly urge you to download it and try out the things we show you! Example: Let’s say you have an inventory list, with multiple items and their corresponding quantity in stock.