Forum Discussion
formatting a cell for specific purpose
Do I understand correctly that now in each cell of first column you have some text ended by dates, i.e.
Me - dob 3.8.2000 is the value of one cell?
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
