Tag Archives: Conditional Formatting
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
How to Format Dates In Excel That Are Over One Year Old To Turn Red, Yellow If Eleven Months Ago, And Green If Between One and Ten Months Ago
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.