FrumpyJones
New Member
- Joined
- Feb 11, 2008
- Messages
- 43
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
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: