Anniversary conditional formatting

Welcome to the forum.

You can get the next birthday from a date using a combination of EDATE and DATEDIF, like this:

Formula:

Please Login or Register  to view this content.

You can then use 14 days before this as a Conditional Formatting formula, like this:
1. Select your range (the range of dates you want to format).
2. On the Home tab of the ribbon, click 'Conditional Formatting', then 'New Rule', then 'Use a formula to determine which cells to format'.
3. In the formula box, enter this, where A2 is the top-left cell of the range you want to format:

Formula:

Please Login or Register  to view this content.

4. Click 'Format' then the 'Fill' tab and choose yellow fill.
5. Click OK twice to get back to the worksheet.

Hope that does what you want.