Premium Only Content
![4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1](https://1a-1791.com/video/s8/1/W/5/s/l/W5slk.qR4e.1-small-4-SMART-Ways-to-use-Custom-.jpg)
4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1
Aug 2, 2017 Excel Dashboards & Reports
Custom formatting is really easy to use once you understand the rule behind it. In this video, I show you a simple way of showing variances using symbols - up/down arrows or any symbol of your choice - with Excel's custom formatting. All you need to know is the rule behind custom formatting - i.e. first argument is how positive numbers should be formatted, then how negative numbers should be formatted, followed by how zero values should be shown and last text. Custom formatting can be confusing, but if you remember this simple rule, you're all set. I cover this also in my free PDF eBook which you can get from my website (see link below).
★ My Online Excel Courses ► https://www.xelplus.com/courses/
Timestamps:
00:00 Why Use Excel Custom Formatting over Conditional Formatting
04:02 Basics of Excel Custom Formatting
08:05 Up/Down Arrows for Deviations with Excel Custom Formatting
12:32 Up/Down Arrows and Percentage Deviations with Excel Custom Formatting
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
⯆ Download the workbook here: http://www.xelplus.com/smart-uses-of-custom-formatting/
For Part 2 watch: https://rumble.com/v2tnemq
We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. Basically to format the numbers in our reports. But we hardly ever use custom formatting to show deviations with symbols. Or to disguise our numbers to look like symbols instead. The trick is super simple.
Why would you want to use custom instead of conditional formatting?
1. Your files will process faster.
2. It's super easy to setup!
This video belongs to a 2 part series. This is part 1 of 2. In the next video, I will show you how you can add thresholds to your deviations using custom formatting.
VBA code from Excel MVP Charles Williams to time your formulas is included here: http://bit.ly/2q1fpSK
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K22 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
66 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
168 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
270 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
5 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
66.8K28 -
37:08
Standpoint with Gabe Groisman
22 hours agoDOGE The UK?! With Liz Truss
26.5K12 -
56:39
SLS - Street League Skateboarding
6 days agoHIGHEST SCORING KNOCKOUT ROUND OF ALL TIME! Felipe Gustavo, Dashawn Jordan, Filipe Mota & more...
21.7K1 -
14:26
Breaking Points
1 day agoWOKE VS BASED?: Saagar And Ryan Play A Game
24.2K6