Tag Archives: Excel Table

Hard-coded range expands automatically with #Excel Table

The INDIRECT trick of using Structured Reference in Conditional Formatting   Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 1 Comment

The INDIRECT trick of using Structured Reference in Conditional Formatting

When setting up conditions for Conditional Formatting in Excel, have you ever tried to set a formula that refers to a Excel Table, but failed?

First of all, why we want to refer to Excel Table in Conditional Formatting? There is one simple answer: To accept new data automatically. 
To use Structure Reference in Conditional Formatting, we need an INDIRECT approach which is discussed here. Continue reading

Rate this:

Posted in Excel Tips | Tagged , , , | 2 Comments

Get a list of pending tasks and sort by due dates

A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment