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 !
Bookmarks