Excel because that starrkingschool.net 365 because that Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel because that Mac 2011 More...Less

Data bars, color scales, and also icon sets are conditional layouts that create visual results in her data. This conditional layouts make it simpler to compare the values of a selection of cell at the very same time.

You are watching: A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

*

*
Data bars

*
shade scales

*
icon sets


Format cells by using data bars

Data bars can assist you point out larger and smaller numbers, such as top-selling and also bottom-selling toys in a vacation sales report. A much longer bar represents a bigger value, and a much shorter bar represents a smaller sized value.

Select the selection of cells, the table, or the totality sheet that you want to apply conditional formatting to.

On the Home tab, click Conditional Formatting.

Point come Data Bars, and also then click a gradient fill or a heavy fill.


Tip: When you make a column with data bars wider, the differences between cell values end up being easier come see.


Format cells by using color scales

Color scales can aid you know data distribution and also variation, together as investment returns over time. Cells room shaded with gradations of two or 3 colors that correspond to minimum, midpoint, and also maximum thresholds.

Select the variety of cells, the table, or the entirety sheet the you want to apply conditional formatting to.

On the Home tab, click Conditional Formatting.

Point come Color Scales, and then click the shade scale format that girlfriend want.

The top shade represents bigger values, the facility color, if any, represents middle values, and also the bottom color represents smaller sized values.

Format cells by using symbol sets

Use one icon set to current data in 3 to 5 categories the are distinguished by a threshold value. Each symbol represents a range of values and also each cabinet is annotated with the symbol that represents the range. For example, a three-icon collection uses one symbol to to mark all values that are greater than or same to 67 percent, one more icon for values that are less than 67 percent and also greater than or equal to 33 percent, and also another icon for worths that are less than 33 percent.

Select the selection of cells, the table, or the totality sheet that you desire to apply conditional formatting to.

On the Home tab, click Conditional Formatting.

Point come Icon Sets, and also then click the icon set that girlfriend want.


Tip: Icon sets can be combined with various other conditional formats.


Format cells by utilizing data bars

Data bars can help you point out larger and also smaller numbers, such together top-selling and also bottom-selling toys in a vacation sales report. A longer bar represents a bigger value, and also a shorter bar to represent a smaller value.

Select the range of cells, the table, or the entirety sheet the you want to use conditional formatting to.

On the Home tab, under Format, click Conditional Formatting.

Point come Data Bars, and also then click a gradient fill or a hard fill.


Tip: When you make a column with data bars wider, the differences between cell values come to be easier come see.


Format cell by using color scales

Color scales can help you know data distribution and also variation, together as investment returns end time. Cells space shaded with gradations of two or three colors that correspond to minimum, midpoint, and maximum thresholds.

Select the range of cells, the table, or the whole sheet the you desire to apply conditional formatting to.

On the Home tab, under Format, click Conditional Formatting.

Point come Color Scales, and also then click the shade scale layout that friend want.

The top color represents bigger values, the center color, if any, represents middle values, and the bottom color represents smaller sized values.

Format cell by using symbol sets

Use one icon set to current data in 3 to five categories that are distinguished by a threshold value. Each symbol represents a selection of values and each cell is annotated v the icon that represents the range. For example, a three-icon set uses one symbol to highlight all values that are greater than or equal to 67 percent, an additional icon for values that are much less than 67 percent and greater 보다 or equal to 33 percent, and also another symbol for worths that are less than 33 percent.

See more: How Do You Know If A Pattern Of Stressed And Unstressed Syllables Called?

Select the range of cells, the table, or the totality sheet that you desire to apply conditional formatting to.