5 Conditional Formatting tips to make you a rock star at work ๐ค
Aah... Conditional Formatting. My most favourite feature of Excel. In this video, let me reveal 5 AMAZING tricks to make you a rock star at work. The five tips are, 1) How to highlight top 3 items & Bottom 3 items 2) Highlight data where sales more than $150,000 3) Highlight top 3 sales persons with CF Formula rule 4) Using Data Bars to add in-cell visualization 5) Creating a stylish report with conditional formatting Video timestamps โฑ๐ ==================== 0:00 - Introduction 0:25 - Highlighting top 3 sales values 1:35 - Highlighting bottom 3 sales values 2:48 - Formula based rule for highlighting sales above $150k 5:09 - Using an input cell to control the format rules 6:26 - Formula rule for highlighting top 3 sales values (RANK.AVG) 8:45 - Adding Databars to instantly visualize your data 9:36 - Making an eye-catching report with CF tricks Sample file ๐๐ ============= Download the sample file from here - https://chandoo.org/wp/wp-content/uploads/2022/03/CF-basics.xlsx More videos on CF ๐ฉ๐ซ๐ช๐ฆ๐ง๐จ ============================== Add color to your spreadsheets with these amazing CF tricks. 5 *must have* Conditional Formatting tricks - https://youtu.be/gpbwBxTRYRM Color change when date changes - https://youtu.be/-bOaYcOAj98 Conditional formatting in Pivot Tables - https://youtu.be/7boz2BtRKmU Highlight overdue items with CF - https://youtu.be/mAOAAQoN4h8 10 Formatting tricks only Excel PROs know - https://youtu.be/2pn47abZCWU #ExcelTips #CF ~ Don't forget to be awesome ๐
Suggested videos

Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)
Chandoo ยท 3:56:43

How to Clean, Analyze and Present Data with Excel (FREE Adv. Course)
Chandoo ยท 1:32:40

Excel Pivot Tables - Master Data Analysis in just 45 minutes
Chandoo ยท 50:06

FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files ๐)
Chandoo ยท 1:54:47

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)
Chandoo ยท 58:22

Beginner to Pro FREE Excel Data Analysis Course
Chandoo ยท 49:16

The Ultimate Excel Dashboard: Visualize Data Like a Pro
Chandoo ยท 29:50

Learn Advance Excel Formulas in an Hour - FREE Masterclass
Chandoo ยท 1:35:00