Conditional Formatting Formula - highlight cells with different values within a criteria

Hi All,

I have a sheet with a column that lists the client account numbers for people who made online purchases over a given period of time (user chooses day, week, month etc). Every transaction for the time period is listed and some clients may have purchased more than once. Another column is for transaction method - AMEX, M/CARD, DEBIT, etc.

I would like to conditionally format the transaction method column to highlight all transaction entries for clients that have used more than one transaction method. Only transaction method needs to be highlighted. The result should look like the image and must work when sorted in any way. Excel sheet also attached for reference.

Is this possible with just conditional formatting?

Thanks in advance for any assistance!

David

You can use the formula

Formula:

Please Login or Register  to view this content.

Thanks for this Trevor - much appreciated. It works perfectly.

Kind regards,

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Originally Posted by sohaila

Is there a way to extract these highlighted values?

In what way? The OP didn't ask to extract any data, simply to highlight instances where clients have used more than one transaction method.

The formula provided (for the purposes of Conditional Formatting) returns True or False. So, that could be used to extract entries.

@sohaila

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread