Conditional Formatting is one of Excel's best features. I use it daily. In this short video, I'll get you started using Conditional Formatting. We will look at using five easy Conditional Formatting features. We will use Conditional Formatting with text, numbers, above average, top 10 and look how to clear rules.
Chapters:
00:00 Introduction
00:29 Tip 1 - Equal To
01:55 Tip 2 - Data Bars
02:47 Tip 3 - Above Average
03:46 Tip 4 - Clear Rules
04:27 Tip 5 - Top 10
05:13 Bonus tip
06:23 Closing remarks
Excel file for Conditional Formatting docs.google.com/spreadsheets/d/1lD_Hv19pryNY4DvwecKcoh5RTnzxWP3K/edit?usp=sharing&ouid=108561963573892143642&rtpof=true&sd=true
Blog post chrismenardtraining.com/post/excel-conditional-formatting-getting-started
#msexcel #chrismenard #chrismenardexcel
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 Conditional Formatting - Getting started with five examples ( Download)
- Excel - Getting Started with Conditional Formatting - Essentials Training ( Download)
- Excel - Advanced Conditional Formatting with sample Excel file - 3 examples ( Download)
- Conditional Formatting In Excel: 5 EASY Examples ( Download)
- Excel Conditional Formatting with Dates - 5 Examples ( Download)
- Conditional Formatting in Excel with 5 most used Examples. ( Download)
- Excel Essentials -- Level UP! -- Conditional Formatting for Due Dates and Expiration Dates ( Download)
- Excel Conditional Formatting with Formula | Highlight Rows based on a cell value ( Download)
- EXCEL Interview Test Questions and Answers 2024 | Difficult Test ( Download)
- Create Conditional formatting with formulas || 5 Useful Examples ( Download)
- Excel Conditional Formatting: Highlight Cells Rules Explained ( Download)
- Conditional Formatting in Excel ( Download)
- Master Conditional Formatting in Excel (The CORRECT Way) ( Download)
- Excel Conditional Formatting ( Download)
- Excel Conditional Formatting (Overview + Advanced Examples) ( Download)
