Highlighting in Excel

  • Thread starter Thread starter excelguy
  • Start date Start date
E

excelguy

I have created a graph that has a row of dates for the next 5 months. I would
like to create this document in such a way that every single day I open the
document on my computer, the particular cell with the date of the current day
is highlighted for me and only on that day. Can this be done?
 
By graph do you mean chart?

If your dates are on an Excel worksheet then you can use conditional
formatting on the cells containing the dates and use the formula
=TODAY() and choose the highlight format you want...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Vba to change displayed year automatically. 14
Need to highlight cells in special order 0
Excel Monthly Spread sheet. 12
If this cell is highlighted, then also highlight these cells 1
Highlight a row in Excel 7
highlight 6
How do I highlight today's date in a monthly schedule spreadsheet. 2

Back
Top