ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Highlighting in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/203355-highlighting-excel.html)

excelguy[_2_]

Highlighting in Excel
 
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?

Sheeloo[_2_]

Highlighting in Excel
 
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...

"excelguy" wrote:

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?



All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com