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

[FrumpyJones]

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

 

[Fluff]

CF cannot see the formatting applied to other ranges, so would have to use the various CF rules for col B on col A.

 

[FrumpyJones]

Hey @Fluff,

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

 

[Fluff]

Fraid not.