Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

How to highlite a birthday

Latest post Fri, Mar 13 2015 9:31 AM by dkv98446. 2 replies.
  • Thu, Mar 12 2015 6:38 PM

    • dkv98446
    • Not Ranked
    • Joined on Thu, Mar 12 2015
    • Tacoma, WA
    • Posts 2
    • Points 26

    How to highlite a birthday

    I have been asked to highlite all of our members' names that have birthdays in the next month. As an example if the spreadsheet is opened this month (March) then she wants all of the APRIL birthdys highlited. I tried to use conditional formatting with the formula =MONTH($I2)=MONTH(TODAY())+1 and highliting LAST NAME ($A2:$A240) FIRST NAME($B2:$B240) BIRTH DATE($I2:$I240) which worked until I tested the December birthdays, when nothing was highlited. I'm at a loss on where to go from here. Because company policy I need to prove an absolute need berfore I can even try writing a macro.

     

    • Post Points: 21
  • Fri, Mar 13 2015 5:45 AM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Re: How to highlite a birthday

    Your problem arises because the MONTH function returns numbers from 1 to 12. You can modify your conditional format formula to

    =MONTH($I2)=MOD(MONTH(TODAY()),12)+1

    Peter

     

    • Post Points: 21
  • Fri, Mar 13 2015 9:31 AM In reply to

    • dkv98446
    • Not Ranked
    • Joined on Thu, Mar 12 2015
    • Tacoma, WA
    • Posts 2
    • Points 26

    Re: How to highlite a birthday

    Thank you Smile

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.