![Daily Office Tips by Office ToDo artwork](https://is1-ssl.mzstatic.com/image/thumb/Podcasts113/v4/b1/76/27/b17627f4-9f9f-1e3a-ecd4-dc23e134b898/mza_6931289376909539342.jpg/100x100bb.jpg)
109 Excel | How to compare values visually?
Daily Office Tips by Office ToDo
English - December 17, 2010 23:01 - 44 seconds - 3.66 MB Video - ★★★★★ - 2 ratingsTechnology Education How To office daily tips word excel powerpoint Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
Previous Episode: 108 Excel | How to clear conditional formatting rules?
Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home tab into Style section. From the row click on the first button called “Conditional Formatting”. From there click on “Data Bars” and apply the style of your liking. Another option would be to add icons inside the cells representing the values compared to other values in the selection. Again, go to the “Conditional Formatting” button and choose “Icon Sets” from the menu. This view offers more possibilities so hover over to see the preview and decide which suits you best. - Office ToDo