Forum Discussion
Conditional formatting a parent cell color based on conditionally formatted child cell colors
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.
I get the following error when trying that formula. I should mention that the Parent Cell would be A1, A2, A3, etc. and the child cells would be A2-A4, B2-B4, etc. Here is an example as well as the error.
