• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to give conditional format when employee code is changed for same employee

Make your range an XL table and use following formula for the CF
=SUMPRODUCT(--($A$2:$A4=$A2),--($B$2:$B4=$B2))=1
format as required
 

Attachments

  • Copy of HIGH.xlsx
    9.3 KB · Views: 5
You must log in or register to reply here.
Back
Top