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...
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
