Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-02-2021, 06:42 PM
Peterson Peterson is offline Conditional formatting showing duplicates across multiple columns not NOT same row Windows 10 Conditional formatting showing duplicates across multiple columns not NOT same row Office 2019
Competent Performer
Conditional formatting showing duplicates across multiple columns not NOT same row
 
Join Date: Jan 2017
Posts: 143
Peterson is on a distinguished road
Default Conditional formatting showing duplicates across multiple columns not NOT same row

I'm able to set conditional formatting to show duplicates across multiple, non-contiguous columns. What I'd like to do is, if any duplicates are on the same ROW, then DO NOT conditionally format them as duplicates. I've not been able to get this to work based on info I've found on a couple websites.


  • For example, below, row Job1 has May 02 twice. I don't want May 02 to show as a duplicate because they're on the same row.
  • Row Job2 has May 15, but so does row Job2, so I DO want these to show as duplicates.
I'm attaching a sample doc and would be grateful for any help. My conditional formatting chops are limited to out-of-the-box stuff, and as noted, wasn't able to get what I found online to work. Thank you!

Code:
Job    Date 1    Date 2    ColumnX    Date 4    Date 5    ColumnY    Date 8    Date 9

Job1    May 01    May 02               Apr 20    May 02               May 15    Jun 01
Job2    May 15    May 16               May 13    May 17               Jun 01    Jun 15
Job3    Jun 15    Jun 18               Jun 10    Jun 15               May 16    Jun 18
Attached Files
File Type: xlsx NoDupesUnlessSameRow.xlsx (10.1 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting showing duplicates across multiple columns not NOT same row Conditional Formatting - Duplicates - Apply to specified range music_al Excel Programming 1 01-25-2017 05:34 AM
Conditional Formatting showing Tracking Status brucesw Outlook 0 12-01-2015 03:21 AM
Conditional Formatting Duplicates Joanne Excel 6 08-05-2013 02:46 AM
Conditional Formatting for columns MattMurdock Excel 1 08-09-2012 10:03 PM
Conditional formatting showing duplicates across multiple columns not NOT same row Using Conditional Formatting to identify duplicates namedujour Excel 3 05-24-2012 05:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft