Forum Discussion
Conditional formatting a parent cell color based on conditionally formatted child cell colors
Good morning all.
I have 1 parent cell A1 and 3 child cells A2-A4. The child cells are conditionally formatted to have a color if the conditions exist. But what I want to do is to conditionally color the parent cell if 2 or more of the child cells have color. Please advise how I might pull this off.
You'll have to create rules for A1 that combine the rules for A2:A4, and check whether two or three of those rules are met.
Without knowing any details it's hard to be more specific...
I set a rule for the child cells to colorize if "yes" is present in the cell. But in the parent cell (A1) I'm struggling to identify a formula that will color A1 in red if 2 or more child cells are colored yellow.
I simplified this just for testing purposes. In the real Excel document, the conditional formatting of the child cells being yellow is based on the top 10 or bottom 10.
For your simplified example:
Create a rule of type "Use a formula to determine which cells to format", with formula
=COUNTIF(A2:A4, "yes")>=2
Edited to replace . with ,
For the real situation, it would be useful to know the exact setup.
