Look Who it Was Random video

Excel - Power of Custom Number Formatting in Excel | Learn to Use All 56 Colors! - Episode 1142

416 views · Published 11 November 2009 · 1:45 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Power of Custom Number Formatting in Excel | Learn to Use All 56 Colors!

Welcome to another episode of the MrExcel netcast, where we tackle Excel problems and find creative solutions. I'm your host, Bill Jelen, and today we're diving into the world of Pivot tables and custom number formatting.
If you've ever been faced with a massive amount of data and wondered how to analyze it, then this video is for you. We'll show you how to use Pivot tables to quickly and efficiently solve complex problems.
But that's not all, we also have a special trick to share with you. This trick was discovered by my colleague Mike Alexander during our Data Analyst Boot Camp. It's a game-changing technique that will make your data analysis even more visually appealing.
You may already be familiar with using colors in the number format, but did you know that you're not limited to just 8 colors? That's right, you can choose from any of the 56 colors in the Excel color palette. And in this video, we'll show you exactly how to do it.
So join us as we explore the endless possibilities of custom number formatting and take your data analysis to the next level. And don't forget to subscribe to our channel for more Excel tips and tricks. Thanks for watching and we'll see you in the next episode of the MrExcel netcast!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Using color in number format
(00:34) Using any of the 56 colors in Excel color palette
(01:01) Specifying color in custom number format
(01:11) Building different colors in custom number format
(01:21) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Color formatting in Excel
Custom number format
Data analysis
Data Analyst Boot Camp
Excel color options
Excel color palette
Excel tips
Excel tricks
Mike Alexander
Pivot table analysis
Positive and negative numbers

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152738/



You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! Episode 1142 shows you how.

More from this channel