Hi, in this blog we take a look how we can highlight a set of rows in Microsoft Excel that fall between two dates.  This is inspired from Rodel Balasabas comment in my other post about highlighting a row in Excel. Thanks!   The final product looks as:   Adding multiple conditions to Excel’s conditional … Continue reading Highlight a set of rows in Excel based on date range

Last time we discussed how to highlight a row in Microsoft Excel automatically. This can be accessed here. Today we will discuss how to highlight a particular entry in a Microsoft Excel chart. The final result is shown in Figure 1. To demonstrate how the above is achieved, we will use the following data: Step … Continue reading Automatically mark the current week in an Excel Chart

In this blog entry we take a look how to highlight a row in a Microsoft Excel table based on a cell value.  First we take a look at the steps required and then we take an example to see it in practice.   We will use the “Conditional Formatting” feature of Microsoft Excel. Steps to … Continue reading Highlight a row in Excel based on a cell value

The article shows a simple way of how to create a drop-down list and proceeds to show how cell values can be changed when the list item selected is changed.