In this post I will explain how to format certain rows in Excel with formatting that matches a condition set you a formula. First lets study the sample dataset in the screenshot below. Observe that the first row of data is … Continue reading
Opening Day for the Reds season is Monday! In honor of this great tradition, I created a video that uses conditional formatting in an Excel which makes the spreadsheet easier to read. . . . Feel free to download the example file below.
I want to share with you how to add gold stars to cells that meet a condition. In my example below, I want to highlight any cell that is greater than 90 for the customer service grade. First I select … Continue reading
Display traffic lights in Excel to track variances of a planned date and the actual date. Continue reading
I’m writing this post in response to a comment that Charles wrote in my “How to change the color of an Excel date to red if over 1 year old” post. It was such a good comment I thought I’d share my … Continue reading
Can you spot the cell that is different than the rest in the screenshot below? Before Select the cells, click the Home tab then Conditional Formatting–> Color Scales. Your outlier will stick out with a different color than the rest. … Continue reading
This video post will share how to create a report in Excel using Icon Sets. Icon Sets are part of the conditional formatting. I share how to customize the icons. For example, each cell with a poor performance will have … Continue reading
Take advantage of Excel’s data bars for rich reporting and analysis. In this video I will teach you how to do some unique customizations with a data bar advancing closer to a set goal.