Results 1 to 4 of 4

Thread: Conditional Formatting: Can I base it off of a group of other CF's?

  1. #1
    New Member FrumpyJones's Avatar
    Join Date
    Feb 2008
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Conditional Formatting: Can I base it off of a group of other CF's?

    Hi again all,

    I have a new hire checklist that has 5 groups and various rows in these grouped rows for each group. (Example rows 3-7 are grouped for network access ID's. rows 8-13 are grouped for software that needs to be installed). Each grouping has its own merged and centered title in Column A, with the individual items in column B

    Each row in a group has 5 checkpoints in columns C through G that are given a "y" or "n".

    I already have every cell in column b conditionally formatted to give me a red, yellow, or green based on various combinations of "y" and "n" and it works great.
    What I would like to add, if possible, is to format the grouping title if all of the items are green.

    I know I could just have it check for all the same conditions in each item that makes each individual item green, but that's a long buncha ANDs (40 for the group that has 8 item rows).

    Is there a way to have the grouped title (Example: A3-A6 in the picture below) look only to the the status of the conditional formatting of B3-B6, and if they all = green then make itself green? Here is a heavily obfuscated image of what I'm talking about



    BONUS QUESTION: Can I have it place a graphic over its title instead? Like a big checkmark or thumbs up? Or is conditional formatting limited to fills and whatnot?

    Thanks in Advance
    Last edited by FrumpyJones; Sep 17th, 2019 at 12:40 PM.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Conditional Formatting: Can I base it off of a group of other CF's?

    CF cannot see the formatting applied to other ranges, so would have to use the various CF rules for col B on col A.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member FrumpyJones's Avatar
    Join Date
    Feb 2008
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting: Can I base it off of a group of other CF's?

    Hey @Fluff,

    Thanks for the reply. I was hoping for the easy way out, but alas

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Conditional Formatting: Can I base it off of a group of other CF's?

    Fraid not.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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