How to Create a Conditional Custom Number Format in Excel

How to Create a Conditional Custom Number Format in Excel

In this video, I show you how you can change the way your data appears based on the value in the cell. I'll use conditional custom number formatting in Excel to show you how to display values that are greater than a certain number in a specific color, values that are between numbers in a specific color and also values that are less than the last value in a specific color. Using the conditional number formatting method applied in this video is a great way to visually identify poor performance for sales revenue or any other metric as well as also identify where you are performing well in your business.

Excel conditional custom number formatting is used in a similar way to the regular formatting but has a few minor differences:

(1) The semicolon (;) acts as a way to split out your conditions for your syntax as opposed to splitting out your number formatting between positive numbers, negative numbers, zero and text.

(2) Square brackets ([ ]) are used to outline the conditions you would like applied to each section of your statement. You can apply color conditional formatting for the text and you can apply formatting using operators and numbers. This simply means that if a number is greater than 10000, you can have your numbers display in a certain way that will appeal to the user.

Checkout the links below for extra and additional aids for learning the topic of conditional custom number formatting in Excel.

-~-~~-~~~-~~-~-
Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard"
-~-~~-~~~-~~-~-

[sandeepbisht]

Who are you Father of Excel or what.... awesome knowledge on tips...