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 anniversaries fallling in each month. How can I set it up ?
For example : Me - dob 3.8.2000 ------ August 3rd.
Can you please help me.
6 Replies
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.
dvyes You could add two columns and enter:
=MONTH(cell)In one column you point to d.o.b., in the other to the anniversary. The picture below demonstrates the principle. Now you can filter on month.
Hi, I dont know whether my message conveyed correctly what I meant. I am attaching a table and want the cells marked ???? to be formatted, so that it acts as remainder for birthday or wedding anniversary 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
