Help with a interactive chart

James818 

At the very simplest level, this turns the cell in row 11 green or red depending on what's in the two cells above that you specifically mentioned. However, what you wrote is a bit confusing:

If any 2 green cells line up in a row (ed. column?) as an example Column E, I would hope to have row 11 light up as good or bad depending on if the above matches green or not.   

Making a cell dependent on 2 cells being green or YES will save up time knowing this is a good time frame for specific process in this legal issue. 

But in Column E every cell is "Yes". Do you mean "any 2" of all of those or only the two that are, in fact, highlighted in Green?

Conditional formatting is most likely what you need. My example does it, but as noted, only at the simplest level. If your conditions are more nuanced, please:

• describe them more fully
• attach an actual sample workbook or post it on OneDrive or GoogleDrive, with a link here that grants access. A picture is worth a thousand words, supposedly, but an actual workbook is easier to work with.