Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |