Highlight Multiple rows in Excel by Cell value, but only in groups and every other section

Posted on 2012-08-22
Last Modified: 2012-08-22
I have a spreadsheet where I want to highlight rows based on the value in column A.  The issue is my client wants each section highlighted by group and every other section to make it easier to read.

Is this possible?

I can read VBA or whatever....
Question by:gracie1972

    Author Comment

    To clarify each auth # in column A, I want each like auth # to highlight the entire row (like auth #'s = 1 group) , but alternating every other group.
    LVL 17

    Accepted Solution

    You can use VBA for this, but it's also possible with conditional formatting and an added 'helper' column to identify the groups - see attached.  The new column A just sets a sequence number on each group, then to define the  conditional formatting, select the entire rows you want to apply it to, add a new rule based on a formula, and enter the formula

    Open in new window

    , with the formatting you require

    Author Closing Comment

    Thank you!

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now