Forum Discussion
Conditional formatting a parent cell color based on conditionally formatted child cell colors
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.
Sorry, child cells would be B2-D2, B3-D3 and so forth.
I had a typo in the formula - it should have used a comma instead of a point.
=COUNTIF(B2:D2, "Yes")>=2