1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22

Looking for a career upgrade & a better salary? We can help, Choose from our no 1 ranked top programmes. 25k+ career transitions with 400 + top corporate companies. Exclusive for working professionals: https://glacad.me/3hyLz55

Get your free certificate of completion for the Excel for Beginners Course, Register Now: https://glacad.me/3wGEV0S

In this video we discuss "Conditional Formatting in Excel". Conditional Formatting is one of the simplest yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set. You can create colour scales, show increasing/decreasing icons, and a lot more using conditional formatting in Excel.

00:00:00 Introduction
00:02:00 Agenda
00:02:36 Formatting
00:03:06 Conditional Formatting
00:07:22 Formatting in Excel
00:12:18 Data Bars
00:14:35 Color Scales
00:17:50 Icon Sets
00:20:08 Cells that contain
00:26:06 More rule type
00:32:27 Formula based
00:35:03 Google Sheets
00:35:28 Color Scales
00:37:56 Top/Bottom values
00:40:19 Unique and similar values
00:42:23 Greater than
00:44:47 Summary

Visit Great Learning Academy, to get access to 300+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/2Td3jK0

Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl

About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.