Forum Discussion
Help with a interactive chart
Hello everyone. I am creating a excel chart for work in the legal field. With constant changes to certain laws, we have a time period to keep in mind if a legal procedure is warranted based on 2 dates.
A little background.
Row 6 (Cells C to H) have a code based on their cell and dates corresponding to row 3 above those coresponding cells.
=IF(AND(L4>=DATEVALUE("10/08/2015"),L4<=DATEVALUE("01/01/2020")),"Yes","No")
If dates entered in L4 & N4 are entered, rows 6 & 9 light up green.
Here is the issue I hope to resolve.
If any 2 green cells line up in a row 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.
I am open to suggestions or alternatives.
I hope my explanation is not too confusing.
Thank you .
4 Replies
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.
- Got one working,
=IF(AND(C6="Yes",C9="Yes"),"Good","Bad")
