Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel won't stop highlighting (Dec 06) | Excel Discussion (Misc queries) | |||
Excel highlighting issue | Excel Discussion (Misc queries) | |||
Highlighting in Excel | Excel Discussion (Misc queries) | |||
highlighting problem in excel | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |