CODEWITHSUNDEEP
excelconditional-formatting
Ravi
Ravi

Reputation: 11

Highlighting conditionally based on the date today

An Excel worksheet contains a datewise list of entries. Whenever I open the worksheet, I want today's date entry to be highlighted. For example, when I open the Excel file containing Interest payment amounts and due dates, it should tell me which Interest is due today.

Upvotes: 0

Views: 249

Answers (2)

amaidment
amaidment

Reputation: 7268

Conditional Formatting is the way to go.

In Excel 2007 (not sure about earlier versions), you can conditional format against formula -- i.e. set a conditional format to equals =TODAY().

(Apologies, I had tried to upload an image for you, but I don't have enough reputation to do so...)

Upvotes: 2

David
David

Reputation: 1611

I'm not sure exactly what you're going for, but if you're attempting to just have the data highlighted you can use conditional formatting to cause the appropriate values to be marked out.

If you're trying to make the data actually be re-ordered or show a sub-set of the existing data onto another tab, you'll need to embed some custom visual basic code into your workbook as a macro-enabled workbook (*.xlsm). There are events inside there that can be called when the workbook is opened.

Upvotes: -1

Related Questions