![]() ![]() Note that all the values below 700 get the same shade of red color.īONUS TIP: Want to show only the colors and not the values in the cells. To do this, select all the cells and press Control + 1. ![]() Now you will get the result as shown below. Since we want to highlight all the cells with a value below 700 in red, change the type to Number and value to 700. Now you can specify the minimum, midpoint, and the maximum value and assign the color to it.In the New Formatting Rule dialog box, select ‘3-Color scale’ from the Format Style drop down.Go to Home –> Conditional Formatting –> Color Scales –> More Options. ![]() So 500 and 650 both gets the same red color since it’s less than 700. For example, you want to highlight all the values less than say 700 in red, irrespective of the value. Now, what if don’t want a gradient and only want to show red, yellow, and green. So there is a gradient with different shades of the three colors based on the value. This will give you a heat map as shown below:īy default, Excel assigns red color to the lowest value and the green color to the highest value, and all the remaining values get a color based on the value. Note that as you hover the mouse over these color scales, you can see the live preview in the data set. The most common color scale is the first one where cells with high values are highlighted in green and low in red. It shows various color combinations that can be used to highlight the data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |