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 e开发者_运维问答ntry 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.

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...)

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.