Some years ago, we saw how one can highlight a row in an Excel table based on a cell value. Today, we are going to look into how to highlight a column instead of a row. It is quite similar, so I will only focus on the change required and explain the functions used. To … Continue reading Conditional highlighting of a column in Excel
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.