bbsinIron ContributorJul 29, 2024conditional 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...Show More
Harun24HRBronze ContributorJul 29, 2024bbsin To highlight cells based on birth month use below conditional formatting rule.=MONTH($A2)=MONTH(B$1:N$1) To highlight first 60 use-=COUNTIFS($B$12:B12,60)=1 highlight_birth_date.xlsx9 KB
