Greetings,
I was hoping someone could assist me with a conditional format custom formula that would compare dates in column A with a Name in Column C and if there is a match to then highlight the duplicate date in Column A.
I've attached a sample workbook with the sample data on the "test" worksheet and another worksheet displays what I'd like the end result to be, etc.
Thanks in advance for any suggestions!
Last edited by lilsnoop; 01-11-2020 at 07:09 PM.
Select test!A2:A9 with A2 the active cell. Use this conditional formatting formula: =SUMPRODUCT(($A$2:$A$9=$A2)*($B$2:$B$9=$B2)*($C$2:$C$9=$C2))>1 . This uses SUMPRODCT rather than a similar COUNTIFS call because you list Office 2007, in which Excel lacks COUNTIFS.
Thanks hrlngrv! Worked perfectly!
Answered already removed my Post.
Last edited by BlindAlley; 01-11-2020 at 07:14 PM.
Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:
Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks