+ Reply to Thread
Results 1 to 3 of 3

Highlight Every Other Dynamic Range

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Highlight Every Other Dynamic Range

    I have data where I would like to highlight every other dynamic group. The unique cell is the vendor cell. See attachment for sample data.

    Thanks,

    Bill
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Highlight Every Other Dynamic Range

    Based on attached file.

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Re: Highlight Every Other Dynamic Range

    Works! However, how can I change it so it doesn't get rid of the grid lines? Attached is what I am seeing.

    Thanks
    Attached Images Attached Images

+ 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. [SOLVED] How to highlight dynamic print area?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-31-2017, 12:00 AM
  2. Dynamic highlight color of cells
    By paul_etl_developer in forum Excel General
    Replies: 7
    Last Post: 04-03-2017, 01:20 AM
  3. Match ComboBox with dynamic range, then add Textbox1 to dynamic range
    By Lasse Moe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 01:26 AM
  4. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  5. Highlight Dynamic Rows
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 03-10-2012, 07:36 PM
  6. Fill Dynamic Range From Dynamic Source Range
    By goss in forum Excel General
    Replies: 2
    Last Post: 03-06-2012, 12:05 PM
  7. Replies: 2
    Last Post: 02-02-2006, 04:10 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