Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
What's the other ways that I can use Conditional Formatting? The first quarter of the year, I want to identify, visually, for the people that are looking at my spreadsheet, which of my sales Channel partners was the most effective. And I can do that by highlighting my sales forecast column for that particular quarter, I'm going up to Conditional Formatting, and in this case, using my Data Bars option. As I hover over my different options, you can see that it identifies for me that my catering group has secured the highest number of sales for that particular quarter because the data bar in that particular row is the largest of the group.
So very, very easily and quickly, I can highlight some trends that are happening with in that particular quarter of sales. So you see that using Conditional Formatting is a very simple way to add visual highlights to your tables. I've now determined that I'm interested in having this kind of visual indicator on my spreadsheet rather then the one that I had when I started. So I want to clear the Conditional Formatting that I have in this section here, so I highlight the area where I would like to remove the formatting, go to my Conditional Formatting command, Go down to Clear Rules, and select Clear Rules from Selected Cells.
That removes any of the Conditional Formatting that was previously added on to that section. To make it match with the section below, I simply leave that section selected, go back up to my Conditional Formatting command, go down to the Data Bars option, and select the second green one. And now I have a consistent look and feel throughout my table. Next we're going to take a look at how can we find cells in a table that have Conditional Formatting already in place.
To find cells that have Conditional Formatting applied, you can use a Find & Select option here on your Home tab. By clicking on that, you would go down to the Conditional Formatting option, select that, and the very first instance of Conditional Formatting found on your screen is highlighted.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91223 Viewers
80 Video lessons · 138197 Viewers
59 Video lessons · 57027 Viewers
52 Video lessons · 70668 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.