Hi,
I have a list which contains a list of activities including duration.
I would like to have conditional formatting highlight any duplicates e.g. in my data set activities 1,3,4 and 6 should flag red as activity 4 runs over the other activities.
In the attached example I have manually highlighted red the conflicts.
This is a partial solution to your query in that it will only highlight offending lines, those that overlap previous entries and not those that are being overlapped. So in the case of your file it will highlight activity 6 as it overlaps the times for activities 1,3, and 4.
I applied the conditional formatting to F12:I35, which omits the first activity in the table as that one can not run over any previous activity times. The CF formula is:Let me know if you have any questions.
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks