Home

Conditional formatting with Dates (for Birthday List)

%3CLINGO-SUB%20id%3D%22lingo-sub-796387%22%20slang%3D%22en-US%22%3EConditional%20formatting%20with%20Dates%20(for%20Birthday%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796387%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'd%20like%20a%20spreadsheet%20where%20the%20first%20sheet%20has%20all%20of%20the%20names%20and%20address%20of%20people%20and%20their%20birthdates%20%26amp%3B%20anniversaries.%20Then%20I%20have%20sheets%20January%20-%20December.%20Each%20sheet%20is%20populated%20with%20the%20names%20and%20addresses%20and%20other%20information%20of%20every%20person%20who's%20birthday%2Fanniversary%20is%20that%20month.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-796387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796485%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20Dates%20(for%20Birthday%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389588%22%20target%3D%22_blank%22%3E%40FINEPOINT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20may%20be%20missing%20something%2C%20but%20where%20do%20you%20want%20to%20see%20the%20conditional%20formatting%20%3F%20is%20it%20on%20Birthday%20field%20of%20Monthly%20(January)%20sheet%20or%20Master%20List%20%3F%3C%2FP%3E%3CP%3Eor%20is%20it%20that%20you%20want%20to%20merge%20all%20the%20birthdays%20in%20the%20master%20sheet%26nbsp%3B%20and%20conditional%20format%20this%20month's%20birthdays%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797799%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20Dates%20(for%20Birthday%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797799%22%20slang%3D%22en-US%22%3EThank%20you%20for%20helping%20me.%20I%20want%20the%20January%20sheet%20to%20only%20have%20the%20rows%20on%20the%20master%20sheet%20where%20there%20is%20a%20date%20in%20the%20row%20with%20a%20January%20date.%20So%20if%20Row%206%20on%20the%20Master%20sheet%20has%20a%20January%20anniversary%20date%20in%20column%20G%20or%20a%20January%20birthday%20in%20column%20F%20then%20the%20entire%20Row%206%20is%20put%20into%20the%20January%20sheet.%3CBR%20%2F%3EThen%2C%20in%20January%20I%20can%20open%20the%20January%20sheet%20and%20see%20what%20type%20of%20cards%20to%20send%20out%20and%20to%20whom.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797801%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20Dates%20(for%20Birthday%20List)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797801%22%20slang%3D%22en-US%22%3EI%20think%20the%20formatting%20for%20the%20January%20sheet%20rows%20needs%20to%20be%20an%20IF%20formatting%2C%20but%20I%20don%E2%80%99t%20know%20how%20to%20phrase%20it.%3C%2FLINGO-BODY%3E
Highlighted
FINEPOINT
New Contributor

Hello,

I'd like a spreadsheet where the first sheet has all of the names and address of people and their birthdates & anniversaries. Then I have sheets January - December. Each sheet is populated with the names and addresses and other information of every person who's birthday/anniversary is that month. Any ideas?

3 Replies

@FINEPOINT 

I may be missing something, but where do you want to see the conditional formatting ? is it on Birthday field of Monthly (January) sheet or Master List ?

or is it that you want to merge all the birthdays in the master sheet  and conditional format this month's birthdays ? 

Thank you for helping me. I want the January sheet to only have the rows on the master sheet where there is a date in the row with a January date. So if Row 6 on the Master sheet has a January anniversary date in column G or a January birthday in column F then the entire Row 6 is put into the January sheet.
Then, in January I can open the January sheet and see what type of cards to send out and to whom.
I think the formatting for the January sheet rows needs to be an IF formatting, but I don’t know how to phrase it.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies