Results 1 to 5 of 5

conditionally format alternate rows every time the unique label changes In column B

Threaded View

  1. 06-14-2016, 05:19 PM #1
    jimcuk
    jimcuk is offline
    Registered User
    Join Date
    10-14-2013
    Location
    uk
    MS-Off Ver
    2016
    Posts
    87

    conditionally format alternate rows every time the unique label changes In column B

    Hi folks

    I would like to conditionally format alternate rows every time the unique label changes
    In column B
    I can get part way there using this formula in column d
    =MOD(SUMPRODUCT(--(C2:C100=C3:C101)),2)

    Which correctly selects the changed rows however I would like the complete row formatted and I would like if possible the alternate rows also formatted

    I have attached an example
    Column a and b is what I would like to end up with.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Moving alternate rows of data to column
    By Corsa88 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-12-2015, 08:28 AM
  2. Best Way to Conditionally Format Range (Multiple Columns and Rows)?
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-14-2013, 04:53 PM
  3. [SOLVED] How to fixed date & time format conditionally
    By nur2544 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2013, 01:39 PM
  4. [SOLVED] Conditionally format: Only if unique identifier and exceeds % of previous record
    By JJ22 in forum Excel General
    Replies: 7
    Last Post: 11-19-2012, 04:28 PM
  5. how do you add up alternate rows in the same column?
    By adrian078 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2007, 12:25 AM
  6. [SOLVED] shading alternate rows, but losing format when one row is deleted
    By Candice in forum Excel General
    Replies: 8
    Last Post: 05-10-2006, 11:10 PM
  7. How can I choose alternate rows in a column?
    By pnair in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-17-2005, 01:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1