Advanced Excel Conditional Formatting Tricks using Dynamic Formulas & Functions || Samina Ghori

Advanced Excel Conditional Formatting Tricks using Dynamic Formulas & Functions || Samina Ghori

Are you ready to take your Excel skills to the next level? In this highly informative video, you'll learn all about advanced Excel conditional formatting tricks using dynamic formulas and functions. Discover how to make your spreadsheets stand out with visually striking formatting effects that respond to changes in your data in real-time. Whether you're a beginner or an experienced user, you're guaranteed to pick up valuable tips and techniques to enhance your workflow. Master conditional formatting like never before and become a proficient Excel ninja by watching this video now!

Timestamps:

00:00 Introduction
00:48 Conditional Format Basic Text
01:27 Highlight 2 Different Static Text Fields
03:12 Highlight 2 Different Dynamic Text Fields
05:28 Highlight Relative Dates
07:01 Greater than Static numerical values
07:44 Dynamic Number Range Formatting
08:34 Highlighting the Full Row based on a Dynamic cell reference
10:22 Data Ranges using Colour Scales
11:02 Icon Sets and how to change the limits
12:14 Adding Data Bars
12:54 Adding Sparklines
13:52 Column Sparklines with High data points
14:23 HighlIght Weekends using WEEKDAY Function
17:15 Outro

👉LET’S CONNECT :

🌐 Website:

👉Instagram: @skillupandexcel
👉Twitter: @skillupandexcel
👉TikTok: @skillupandexcel

💞S U B S C R I B E so that we can be together for a long time!! Thank you so much for watching! I appreciate you so much!💖

_______________________________________________________________

OTHER VIDEOS:


_______________________________________________________________

Thank you for watching

Please like, comment, subscribe, and hit the bell 🔔 so you never miss any videos!

#Excel #ExcelTips #ExcelTutorial #ConditionalFormatting #AdvancedExcel #ExcelSkills #ExcelTraining #DataVisualization #ExcelFunctions #WEEKDAYFunction #ExcelProTips #DataAnalysis #MicrosoftExcel #SpreadsheetTips #ExcelHacks #ExcelFormulas #DataManagement #ExcelHelp #ExcelLearning #ExcelExperts #TechTutorials #SkillUpAndExcel #ExcelForBusiness #ExcelMastery #ExcelTricks #BusinessAnalytics #ExcelCommunity #SpreadsheetSkills #LearnExcel #ExcelGuide

[ianl]

Great video. My favourite is the weekend CF as I'm in the process of creating a dynamic calendar.
Ah yes, DYNAMIC FORMATTING... One of the golden rules of Excel... *Don't hardcode if avoidable.* Too many spreadsheets fail because of unnecessary hardcoding, especially trying to go back and make changes. Of course, we can keep all of the other rules by rearranging the order of priority by clicking on the up and down arrows to suit our own needs.

[attakhan]

It will be very helpful and appreciating if you kindly make a series on excel data analytics especially on these topics e.g. Data Cleaning, Essential Functions, Pivot tables, Power Query, Power Pivot & DAX, Data Visualization and Dashboards alongwith practice files. Thanks

[erikmgrant]

Results at 3:07 show IT & Marketing higlighted for the new rule was for HR & IT

[NAVEENSHARMA-kn]

Ma'am aap kitna accha bolti hai...I was listening you rather understanding the concept.