Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Intermediate Excel!
You have completed Intermediate Excel!
Preview
Getting Fancy with Conditional Formatting
4:33 with Tyler TallonLet's look at a few ways to use conditional formatting to add color to your spreadsheets.
Downloads
Please note that this is a new spreadsheet, different from the one you used in the previous stage:
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
And then go to Conditional Formatting and
Color Scales.
0:00
And then let's choose the top left
one which is Green, Yellow, Red.
0:00
This is the type of heat map that
shows us where values fall in a range.
0:06
Greens are highest values in the range and
red are lowest.
0:10
And the yellows and
oranges are more mid-range values.
0:15
You could also reverse it
to show red is highest and
0:19
green is lowest by choosing
the second options.
0:21
I'll hover over the rest
of the options here, so
0:25
you can see the different color
options you have for Color Scales.
0:27
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up