Apply Conditional Formatting to entire ROW Using Formulas in Excel & Google Sheets
#DataAnalysis #Excel #GoogleSheets #ConditionalFormatting #FormatRow #REGEXMATCH #inventoryManagement
In this video you will learn how to conditional format entire row in both excel and google sheets using cell reference / depending on value in a cell, using REGEXMATCH function
Also how to create dropdowns in data validation
To format an entire row you will need to write a simple formula for the Conditional Formatting rule. This is so that we can specify the column we are testing. This video tutorial shows you step by step
✅ DOWNLOAD the excel document from link:
Google Sheet :https://docs.google.com/spreadsheets/...
Excel: https://drive.google.com/file/d/1R05L...
⌚ Timestamps
0:00 Introduction
0:49 Condition formatting entire row in Google sheets
4:19 Data validation in Google sheet
6:30 Inserting a condition formula using Cell reference value
10:53 Using REGEXMATCH
13:38 Condition formatting entire row in Excel
20:10 Wrap up
🚩 Connect with me on social
1️⃣ LinkedIn:www.linkedin.com/in/christophersabiti/
2️⃣ Twitter: / sabiti14
3️⃣ Facebook: / sabiti.christopher
4️⃣ TikTok: tiktok.com/@sabtechonline
🔔 Subscribe to my YouTube channel
https://www.youtube.com/c/sabtechonli...
🎬 Want to watch again? Navigate back to my YouTube channel quickly
/ @sabtechonline
#Excel #Dashboard #Excel_dashboard #free_templates #excel_template #free_Excel_Template #Interactive #Dynamic #professional #Infographics # KPIs #SLA #Service_Level_Management #HR #PowerpointSlides #createpresentations #GraphicDesign #BuisnessPurpose #PowerPoint #RealEstate #Villa #PropertyManagement #Property #other_level's #other_levels #otherlevel's #PowerPoint #Tutorial #how_to_create #dashboard #Dashboards #excel_dashboard #PowerPoint_dashboard #excel_report #School #PowerPoint_presentation #PowerPoint_templates #Presentations #Freetemplates #free_Templates #Video_Tutorial #KPI #SLA #Service_level_Managment #Excel_Dashboard #Chart #data_analyst #PowerBI #GoogleDataStudio #GoogleSheets