How to Change the Number Format of a Cell Based on a Condition in Excel

How to Change the Number Format of a Cell Based on a Condition in Excel

 

 

Quickly learn how to change the number format of a cell based on the value of another cell. In this example, I show you how you can format a cell so its number format switches between currency and no currency. We can also switch the formatting of a cell to Bold and Regular depending on a condition.  

Related Topics:

• Excel's Find and Replace (surprising features)
• Calculate Percentages the Right Way in Excel (% Change and Amount after % increase) 
• All about Excel Comments ( Notes ) in 8 Minutes! Shortcut Keys, Customize Background and More
• Excel Header and Footer ( Quickly Copy to other Sheets)