Excel Dashboard Course #4 - Using Custom Number Formatting

In this video, I will cover all you need to know about custom number formatting to create amazing Excel dashboards.
Custom Number formatting allows you to format a cell and show the value in a specific format. For example, you may want to show all negative values in red or all percentage values with two decimals.
In this video, I cover the following:
-- Accessing Custom Numer Formatting Options
-- Custom Number formatting Examples
✅ Download File - trumpexcel.com...
☕ If you find the videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial

[@saravanans5646]

Had doubts about some custom formats. Now it's clear. Thank you, Admin

[@vijithpujari2925]

great work with uploading videos as a course .. very rare to find it on youtube .. ppl usually upload randoms clips which not a right guide for amateurs like me in excel

[@sv4430]

zero dislike shows how great he is. Thanks Sumit.

[@UOFacts]

You are doing great job .. Spreading knowledge..nice action..

[@nadermounir8228]

Great tutorial Sumit. Amazing work 👏

[@motherslap-myjourney3384]

Simply awesome!!

[@MARWAN-ABDELFATTAH]

Thanks a lot Mr. Somit

[@sivas9443]

God Bless you ! thanks for your wonderful videos !

[@margad-erdeneboldbaatar4704]

Great work.

[@hawtin135]

Excel-ent video Sumit

[@techcrumbs6032]

great video thanks

[@martinargimon730]

HI Summit. I wanted to "BOLD" my numbers under 'Custom' formatting and i do not seem to get it right . In other words for example I know that i can add [Red} in brackets to get the numbers to show in 'red' font, but how do i get them to show in 'Bold ? ( by the way the [Bold] in brackets do not work. Any pointers>? please thx martin

[@zahavasantos902]

How do you make a date thats 0 which is showing 0-Jan-00 into Blank or a dash ?

[@rawanalghamdi2755]

Great 👍🏽

[@anushapoddar5107]

Great...!!!

[@aakashkhatri9271]

what about negative numbers

[@rohitbhateja8022]

When I enter 1 it appears as 0.000001. Kindly help

[@ayehninkhine5029]

I was put just like [>99]'Pass';'[

[@lakshmi5natarajan]

eg : first have scores in B column: =IF(B2

[@phoebenguyen3272]

try ' as "

[@UpcomingJedi]

view -- 7 Clever Excel Custom Formatting Tricks (Advanced) -- which this question is answered when the score is [>35]pass. Anything less than 35 would show fail.

[@SyedAbdulHaseeb]

Killer 🤣 😛😜