Forum Discussion

James818's avatar
James818
Brass Contributor
Aug 08, 2023

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 dat...
Charting
excel
Formulas and Functions
James818's avatar
James818
Brass Contributor
Aug 08, 2023

mathetes 

 

 

 

Row 11 cells would be good/green only when the 2 cells above (Rows 6 & 9) of that specific column are both green/Yes only.  

 

 I attached a screen shot in theory how I would hope it to look. 

 

I am having issues uploading a file copy, I may need to wait until I get home. 

 

 

James818's avatar
James818
Brass Contributor
Aug 08, 2023
Got one working,

=IF(AND(C6="Yes",C9="Yes"),"Good","Bad")

  • mathetes's avatar
    mathetes
    Gold Contributor
    Aug 08, 2023

    James818 

     

    Got one working,
    =IF(AND(C6="Yes",C9="Yes"),"Good","Bad")

     

    Yes. That's the formula (with relative references changed for different columns) that goes in Row 11.

     

    Then this pair of conditional formatting rules sets the cell in Row 11 to Green or Red as needed. See attached.

     

Resources