highlight color based on the status - conditional Formatting | ExcelWizards7
Stop highlighting colour manually
If you want to highlight colour based on the status then do below.
Select the Data
Go to Home Tab - styles - conditional formatting - click on Drop-down - select new rule - select option use a formula to determine which cell to format
Then select first cell status from the range
Then remove $ sign before row no
Then enter this formula
$J3="Not Started"
Then click on format and do required cell formatting like background color, font etc
Once it is done click on ok
For second condition repeat same thing
Select the Data
Go to Home Tab - styles - conditional formatting - click on Drop-down - select new rule - select option use a formula to determine which cell to format
Then select first cell status from the range
Then remove $ sign before row no
Then enter this formula
$J3="In Progress"
Then click on format and do required cell formatting like background color, font etc
Once it is done click on ok
For third condition repeat same thing
Select the Data
Go to Home Tab - styles - conditional formatting - click on Drop-down - select new rule - select option use a formula to determine which cell to format
Then select first cell status from the range
Then remove $ sign before row no
Then enter this formula
$J3="Closed"
Then click on format and do required cell formatting like background color, font etc
Once it is done click on ok
Now this will be dynamic colour change, if you change status then colour highlights will also get changed.
#conditionalformat #excel #exceltips #exceltricks #exceltraining #spreadsheets #trending #learning
ExcelWizards7 - Your Ultimate Excel Learning Hub
Welcome to ExcelWizards7, your one-stop destination for all things Excel! Whether you're a beginner looking to learn the basics or an experienced user seeking advanced tips and tricks, our YouTube channel is here to empower you with the knowledge and skills you need to become an Excel pro.
🔗 Subscribe for Excel Excellence: / @excelwizards7
📊 Why Choose ExcelWizards7? 📊
At Excel Wizards, we believe that Excel is more than just a spreadsheet software – it's a powerful tool that can transform the way you work, analyze data, and make informed decisions. Our mission is to make Excel accessible and enjoyable for everyone, regardless of their skill level. Here's what you can expect from our channel:
🔹 In-Depth Tutorials: Our comprehensive tutorials cover a wide range of topics, from Excel basics like creating spreadsheets and formatting cells, to advanced functions, pivot tables, and data analysis techniques.
🔹 Tips and Tricks: Discover hidden gems and time-saving shortcuts that will boost your productivity and efficiency in Excel. Impress your colleagues with your newfound expertise!
🔹 Real-World Examples: Learn how to apply Excel skills in real-world scenarios, such as financial analysis, project management, data visualization, and more.
🔹 Problem-Solving: Stuck on a tricky Excel challenge? Our problem-solving videos will guide you step-by-step through solving common issues and roadblocks.
🔹 Excel for Professionals: If you're in the business world, our channel provides insights into how Excel can enhance your job performance and open up career opportunities.
🔹 Updates and New Features: Stay up-to-date with the latest Excel features and updates. We'll guide you through any changes and show you how to leverage them effectively.
Join our vibrant community of Excel enthusiasts, where you can share your insights, ask questions, and connect with fellow learners. Whether you're a student, professional, entrepreneur, or simply curious about mastering Excel, our engaging and easy-to-follow tutorials will empower you to unlock Excel's full potential.
🌐 Connect With Us 🌐
Instagram: / excelwizards7
Threads: https://www.threads.net/@excelwizards7
YouTube: / @excelwizards7
LinkedIn: / 9507218
Twitter: / excelwizards7
Gmail: [email protected]
Facebook: / excelwizards7
Don't miss out on the Excel revolution – subscribe now and embark on your journey to Excel excellence with Mastering MS Excel! 🚀📈
Watch video highlight color based on the status - conditional Formatting | ExcelWizards7 online without registration, duration hours minute second in high quality. This video was added by user ExcelWizards7 07 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1 once and liked it people.