Hi

I am working in HR dept. I had made an excel with all the necessary dates like DOB DOJ Passport expiry date etc.

In column birthday - if anyone's birthday is today - i need that cell to be highlighted.

I put this formula - " =MONTH(cell number)=MONTH(TODAY())" to highlight all the cells having that particular month : conditional formatting to font color change & to become bold.

Then I put this formula - =(MONTH(TODAY())=MONTH(cell number))*(DAY(TODAY())=DAY(cell number)) : conditional formatting to fill that cell with a different color.

But instead of the cell containing the date to be filled with color, the cell which is two rows above is getting formatted. (for eg: if cell N33 was having the desired value; cell N31 is getting formatted).

Hope the issue is clear.

Please advise !