+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting groups of data

  1. #1
    Registered User
    Join Date
    05-19-2014
    Location
    UK
    MS-Off Ver
    Standard 2016
    Posts
    15

    Conditional formatting groups of data

    Hi all,

    I have a spreadsheet with data in a table with order numbers in column A. Although each order is given a unique number, the data populates with multiple rows, one for each line of the order, all with the same order number depending on how many lines where on the order (which is generated via other software and cannot be altered). Therefore the data, when sorted by order number, appears in groups:

    \1

    Is it possible to conditional format each line in groups of the same order number to make it easier to differentiate between each individual order which will still work when the data is sorted or filtered? Any suggestions on how to go about this would be very much appreciated as I have been googling all night and making little headway!

    Thank you in advance
    Attached Images Attached Images
    Last edited by ey_up; 05-28-2014 at 05:24 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Conditional formatting groups of data

    Hi ey_up

    The way I would do this is to set up a helper column which checks for a change in order number and set up conditional formatting on that. I have shown 2 colours (plus no colour) but it can be amended to any number of different colours.

    Regards
    Alastair
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-19-2014
    Location
    UK
    MS-Off Ver
    Standard 2016
    Posts
    15

    Re: Conditional formatting groups of data

    aydeegee, that is great. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 12-26-2012, 07:54 AM
  2. How to separate out groups of cells based on conditional formatting AND account #?
    By coco1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2012, 01:34 PM
  3. Excel 2007 : formatting data to extract into groups
    By Blakespops in forum Excel General
    Replies: 1
    Last Post: 10-13-2011, 01:49 PM
  4. [SOLVED] Conditional Formatting - Drawing Lines Between Sorted Groups
    By Sam via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 05-26-2006, 10:10 AM
  5. [SOLVED] Conditional formatting for groups
    By RobRed in forum Excel General
    Replies: 1
    Last Post: 03-11-2005, 05: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