In this video, I demonstrate an advanced method of using Conditional Formatting in Excel to identify numbers over a specific value. Unlike the conventional approach, I employ Mixed and Absolute References to enhance precision and flexibility.
This tutorial covers selecting the relevant data, applying Conditional Formatting with both basic greater than rules and a formula-based method that incorporates references.
I highlight the benefits of this advanced method, especially its clarity and ease of modification, by changing one reference cell value. This video is aimed at providing a clearer and more efficient way of utilizing Conditional Formatting in Excel, suitable for both personal use and sharing spreadsheets with others.
Check out my Microsoft Excel and Teams Courses:
courses.chrismenardtraining.com
Chapters:
00:00 Introduction
00:28 Applying Basic Conditional Formatting
01:17 Removing Conditional Formatting
01:37 Setting Up for Advanced Conditional Formatting
01:50 Conditional Formatting with Mixed and Absolute References
03:11 Benefits of Advanced Conditional Formatting
03:59 Conclusion
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 #conditionalformatting #chrismenard
- Advanced Excel Conditional Formatting with Mixed and Absolute References ( Download)
- Excel Conditional Format Mixed References - Episode 2105 ( Download)
- Excel Cell Reference: Absolute, Relative or Mixed ( Download)
- Excel - Advanced Conditional Formatting with sample Excel file - 3 examples ( Download)
- Mod 3 - 10 Conditional Formatting with Relative and Absolute Referencing ( Download)
- MS Excel - Cell Reference ( Download)
- How To Use Relative & Absolute Cell References In Excel ( Download)
- 5 Conditional Formatting tips to make you a rock star at work 🤘 ( Download)
- 4-18: Conditional Formatting with Formulas - Defining Custom Rules ( Download)
- Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References ( Download)
- IF Function with 4 Criteria in Excel | IF Formula with many Conditions ( Download)
- Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value ( Download)
- Excel 2019 Exam MO-200 - Using Relative, Absolute, and Mixed References ( Download)
- Change color when date changes ~ Powerful Conditional Formatting Trick 💡 ( Download)
- Conditional Formatting using XLOOKUP and FILTERS Functions in Excel for the Web ( Download)
