Forum Discussion
formatting a cell for specific purpose
I am preparing a family details table, where in columns are created for entering actual dates of birth and wedding anniversary. Now I wish to open new columns to highlight birthdays or wedding a...
I dont know if I conveyed what I wanted correctly. I am attaching a table and want to format the cells marked ???? so that it can act as a remainder for birthday or wedding day in any year.
| Ist Generation | 2nd Generation | 3rd Generation | Date of Birth | AGE | Wedding Date | No. of yrs of marriage | Mobile Number | BIRTHDAY | WEDDING ANNIVERSARY |
| Devendra Kumar V Shah | 3-Aug-1950 | 69 | 11-Feb-1976 | 43 | 95900 25888 | ????? | ????? | ||
| Rekha D Shah | 10-Aug-1951 | 68 | 11-Feb-1976 | 43 | 93412 55287 |
It depends on which kind of reminder is more suitable. If simply to show the month of the event, when as Riny_van_Eekelen suggested to use MONTH() function.
As variant you may apply conditional formatting to birthday and wedding date columns. Let say dates will be highlighted as yellow is the event is within two months, blue if within one month, green if within one week and red if tomorrow or today.
If that's an option just define which rules are suitable, we could help with the implementation.
- Thanks for suggestions.
I solved it differently. In the last column cell i put in a formula =if(text(e6,"mmm)=text(today(),"mmm"), text(e6,"dd"), " ")
This coated the month of birth with presentonth and if found same highlighted date of birth !!
Working fine.
Thanks