From the course: Excel: Introduction to Formatting
Join today to access over 24,900 courses taught by industry experts.
Color scales - Microsoft Excel Tutorial
From the course: Excel: Introduction to Formatting
Color scales
Excel conditional formatting color scales are a useful tool for creating heat maps, allowing you to quickly identify patterns and trends in large data sets. In this video, we'll apply color scales to highlight the relative values of cells within a range. Taking this example of student test data, which is a sea of numbers, makes hard work for the teacher to quickly identify and focus on students who are below average. I'll select the data containing the text scores and then on the Home tab, Conditional Formatting, Color Scales. Hovering over the color scales gives me a preview. I'm going to stick with this traditional green, yellow, red color scale. And now I can instantly focus on the below average students as their test scores are shaded in red. And if I sort the data, select it, data tab, sort. Let's sort it based on the average test score from smallest to largest. It's now even easier to use. If your audience is vision impaired, then this color scale may not be ideal, in which case…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.