Excel - Getting Started with Conditional Formatting - Essentials Training
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 https://drive.google.com/file/d/1cAQW...
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips • Excel PivotTable - Percentage of Row ...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Conditional Formatting w...
Teams Online Course Promotion • Teams Online Course Promotion
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Percentages - Grand...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting • Excel - Turn on Multiple Filters in a...
Excel - Filter a PivotTable with a Timeline • Excel - Filter a PivotTable with a Ti...
PivotTables - 3 Annoying Things FIXED! • PivotTables - 3 Annoying Things FIXED!
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines on a Separate Wo...
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used with the Geogra...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text and Dates with...
Tasks by Planner in Teams - Recurring Tasks - New Feature • Tasks by Planner in Teams - Recurring...
Excel - Insert a blank row after every row or every Nth row • Excel - Insert a blank row after ever...
#chrismenardtraining #exceltraining #msexcel
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.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!
Watch video Excel - Getting Started with Conditional Formatting - Essentials Training online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 14 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 87 once and liked it 5 people.