How to create color scales [Conditional Formatting]
Color scales in conditional formatting applies a color to cells in a cell range based on their values, this lets you easily spot maximum and minimum values as well as trends.
How to build
- Select cell range.
- Go to tab "Home" if you are not already there.
- Click the "Conditional formatting" button.
- Click or hover over "Color scales" with the mouse pointer.
- Pick a predefined color scale or click "More Rules" to define your own scale and colors.
How to customize Color scales
If you want to change the settings for an existing cell range follow these steps:
- Select the cell range.
- Go to tab "Home" on the ribbon.
- Click "Conditional formatting" button.
- Click "Manage Rules..."
- Click "Edit Rules..."
To create a new color scale and also edit settings before creation then follow these steps:
- Select cells.
- Go to tab "Home" on the ribbon.
- Click the "Conditional Formatting" button.
- Click "Color scales".
- Click "More Rules..."
The settings dialog box appears.
Here you may change the Format style to a 2-Color Scale or 3-Color Scale. The minimum and maximum drop-down lists allow you to change how min and max values are calculated:
- Lowest/Highest
- Number
- Percent
- Formula
- Percentile
How to insert icons representing cell values [Conditional formatting]
Conditional formatting lets you insert icons based on cell values, the idea is to make the data easier to read, […]
How to add Data Bars to your worksheet
Data bars allows you to insert a data bar into each cell in the selection, the size is based on […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.