Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
it is dificult to explain exactly the whole proBlem, i have explain it Better
in a question that i post here But didn't have awnser that had worked. The post is "Match date problem" Is a complex proBlem. Thanks "David Biddulph" escreveu: You haven't said what you want to do if you match the date, but assuming that you want to highlight that date with cell formatting, try formatting cell B2 by Format/ Conditional Formatting/ Formula is: =TODAY()=DATE($AK2,MONTH($A2),B2), then choose an appropriate format (and copy the format to the other cells). [I'm assuming that column A are not text entries for month names, but dates formatted as mmm or something similar to show the month name; that makes it easier.] -- David Biddulph "Micos3" wrote in message ... I have a calendar in wich i need that it recoginizes the day where it is today, to do what i want. Tha calendar has Month Col A, Days in other columns and in Col AK has the year. How can i do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match date problem | Excel Discussion (Misc queries) | |||
Match Problem | Excel Discussion (Misc queries) | |||
Lookup/Match Problem | Excel Worksheet Functions | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
match problem | Excel Worksheet Functions |