Advanced Conditional Formatting in Excel | By BK's Excel Network
Conditional formatting is a fantastic way to quickly visualize data in a spreadsheet. With conditional formatting, you can do things like highlight dates in the next 30 days, flag data entry problems, highlight rows that contain top customers, show duplicates, and more.
Excel ships with a large number of "presets" that make it easy to create new rules without formulas. However, you can also create rules with your own custom formulas. By using your own formula, you take over the condition that triggers a rule, and can apply exactly the logic you need. Formulas give you maximum power and flexibility.
For example, using the "Equal to" preset, it's easy to highlight cells equal to "East".
But what if you want to highlight cells equal to "East" or "West" ? Sure, you can create a rule for each value, but that's a lot of trouble. Instead, you can simply use one rule based on a formula with the OR function:
=OR($D4="West",$D4="East") for more information refer video.
Follow us at
Facebook
/ bkexcelnetwork
Instagram
/ bkexcelnetwork
Twitter
/ birukolekar
Telegram
https://t.me/bkexcelnetwork
WhatsApp
https://wa.me/+919762646663?Text=
#MSExcel #AdvancedExcel #ConditionalFormatting #ERP #PowerPivot #PowerMap #PowerQuery #TallyPrime #TallyUpdate #TallyNewRelease #TallyCourse #TallyOnline #TallyonCloud #Corporate_Trainer #BiruKolekar #TallyExpert #TallySpecialist #BKExcelNetwork #BiruKolekar #CorporateTrainer