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
Category: Office
Rotating Table in MS Word
Unfortunately, there is no option to rotate a table in MS Word. However, it is still easy to accomplish by following the simple steps below. 1) Insert a Text Box where you want to add your table. 2) Then insert a Table in the Text Box you created in (1). 3) Click on the Text … Continue reading Rotating Table in MS Word
Highlight a set of rows in Excel based on date range
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
Automatically mark the current week in an Excel Chart
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
Highlight a row in Excel based on a cell value
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