Results 1 to 7 of 7

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

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-08-2013
    Location
    London
    MS-Off Ver
    365
    Posts
    136

    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
    Attached Images Attached Images
    Attached Files Attached Files
    Dave C

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using conditional formatting to highlight dates with formula (certain criteria)
    By Gisela1209 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2020, 04:38 AM
  2. Replies: 3
    Last Post: 10-17-2018, 01:57 AM
  3. [SOLVED] Conditional Formatting formula to highlight a column if multiple criteria are not met.
    By KMJ256388 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2018, 09:36 AM
  4. [SOLVED] Conditional formatting to highlight cells of different values
    By stuver in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2017, 09:45 AM
  5. Replies: 3
    Last Post: 02-26-2014, 12:10 AM
  6. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  7. Replies: 3
    Last Post: 05-11-2013, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1