Conditional Formatting in Excel allows you to easily highlight information. For example, you may want everyone in the Accounting Department to show in a yellow background, or you may want any numbers over 100 to show in a blue font and grey background. Conditional Formatting has two huge advantages over manually highlighting data. One, it is much quicker and more accurate. If you manually try to select the Accounting Department, you can make a mistake, and it is time-consuming. Another advantage is if the data changes, the Conditional Formatting ticks in.
Conditional Formatting is located on the Home Tab in the Styles Group. The categories for Conditional Formatting include Highlight Cells Rules, Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets. You can also write your own rule, clear rules, and manager rules.
Screenshot drive.google.com/file/d/1cAQWQr45biqUCCac0KNt1SqYy9EAa16V/view
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips youtube.com/watch?v=6v2aj1GE3fg
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY youtube.com/watch?v=uCmmuScmxQk
Teams Online Course Promotion youtube.com/watch?v=KJgxWOqdZHE
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total youtube.com/watch?v=KSaM8JAVnSo
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting youtube.com/watch?v=qFnHYfn6yNs
Excel - Filter a PivotTable with a Timeline youtube.com/watch?v=FIKqdUC92f4
PivotTables - 3 Annoying Things FIXED! youtube.com/watch?v=U746wZCrq6k
Excel Add Sparklines on a Separate Worksheet youtube.com/watch?v=163KG9gImPI
Excel Chart Maps used with the Geography Data Type youtube.com/watch?v=iQvapFfAoEE
Excel Concatenate Text and Dates with the TEXT function youtube.com/watch?v=hljBSRnKZp4
Tasks by Planner in Teams - Recurring Tasks - New Feature youtube.com/watch?v=byV-dsWCrU0
Excel - Insert a blank row after every row or every Nth row youtube.com/watch?v=FPu3nJBwgEc
#chrismenardtraining #exceltraining #msexcel
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
- Excel - Getting Started with Conditional Formatting - Essentials Training ( Download)
- Excel Conditional Formatting - Getting started with five examples ( Download)
- Excel Essentials -- Level UP! -- Conditional Formatting for Due Dates and Expiration Dates ( Download)
- Conditional Formatting in Excel Tutorial ( Download)
- Conditional Formatting in Excel | Excel Tutorials for Beginners ( Download)
- Excel Essentials Level 2 -- Conditional Formatting ( Download)
- Applying Conditional Formatting in Microsoft Excel ( Download)
- Excel Tutorial - CONDITIONAL FORMATTING for beginners ( Download)
- Build a Data Entry Form in Excel Easily Today | Raj Singh Microsoft Certified Trainer ( Download)
- Accountant Excel Tip Part 1, conditional formatting ( Download)
- Excel Conditional Formatting in Depth ( Download)
- Conditional Formatting in Excel | Tutorial for Beginners ( Download)
- Conditional Formatting in Excel ( Download)
- Boost Productivity: Excel Checklists and To-Do Lists Using Conditional Formatting #howto #tutorial ( Download)
- MS Excel - Conditional Formatting Part 1 ( Download)
