Lesson 226: Color Scales in Excel

This article will show you how to use Color Scales in Excel.

Color Scales

This article will guide you to use Color Scales

1. Select range

2. On the Hone panel in the Styles Group select Conditional Formatting

3. Click Color Scales to select

Result:

4. Select range A1:A7

5. On the Hone panel in the Styles Group select Conditional Formatting, Manage Rules.

6. Click edit rules

7. Select 2-Color Scale in Formaat Style

8. Click OK 2 times

Result

In addition, you can also see many other excel articles here.