Change number format based on cell value | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ https://exceloffthegrid.com/change-nu... ★ About this video ★ You've built an amazing dynamic report where a user can select a business unit to view, and everything updates automatically - it's beautiful. The only issue is that Company A has sales of $30,000,000, Company B has sales of $30,000. Displaying values in 1 decimal place millions makes sense for Company A. $30,000,000 becomes $30.0m. But it does not make sense for Company B. $30,000 become $0.0m - pretty useless. The companies have different levels of significance. How can we format numbers so they work with either company? We will look at two techniques in this post. 0:00 Introduction 0:33 TEXT Function 3:02 Conditional Formatting 5:50 Conclusion What to know more about number formats? Check this out:    • Excel number formats for accounting & fina...   ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel