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/upl...
More videos on CF 🟩🟫🟪🟦🟧🟨
==============================
Add color to your spreadsheets with these amazing CF tricks.
5 must have Conditional Formatting tricks - • 5 *Must have* Excel Conditional Forma...
Color change when date changes - • Change color when date changes ~ Powe...
Conditional formatting in Pivot Tables - • Advanced Pivot Tables #10 - Condition...
Highlight overdue items with CF - • Highlight overdue items using Conditi...
10 Formatting tricks only Excel PROs know - • 10 Excel formatting tricks *ONLY* exp...
#ExcelTips #CF
~
Don't forget to be awesome 😎
Watch video 5 Conditional Formatting tips to make you a rock star at work 🤘 online without registration, duration hours minute second in high quality. This video was added by user Chandoo 24 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 174,990 once and liked it 4 thousand people.