conditional formula excel
Hi
I have a question and need help find 3 items
1) How use conditional formula and highlight the month based on the DOB
2) How to use conditional formula to highlight in the month turn first 60 based on the birth month (eg the last row should highlight Jan – 60)
Thank you
Birth dateDec 23Jan 24Feb 24Mar 24Apr 24May 24Jun 24Jul 24Aug 24Sep 24Oct 24Nov 24Dec 243/23/1948757575767676767676767676762/5/1956676768686868686868686868681/31/196459606060606060606060606060
Hi I have a question and need help find 3 items1) How use conditional formula and highlight the month based on the DOB2) How to use conditional formula to highlight in the month turn first 60 based on the birth month (eg the last row should highlight Jan – 60) Thank youBirth dateDec 23Jan 24Feb 24Mar 24Apr 24May 24Jun 24Jul 24Aug 24Sep 24Oct 24Nov 24Dec 243/23/1948757575767676767676767676762/5/1956676768686868686868686868681/31/196459606060606060606060606060 Read More