Indirect Formula

[Treesh1994]

What I am looking to do is if column AD in "2024 SEP Work Charts" drop box says "Yes" Or "Yes With Problems" the whole row in "2024 SEP Work Charts "B" Shop" turns green.

I am new to the indirect formulas and cannot figure out how to get this to work. Maybe using indirect isn't the answer but it's what I have gathered when using 2 different tabs on google sheets.

Any help would be greatly appreciated.

Below is the link to the document.

Copy of 2024 SEP Work Chart

2024 SEP Work Charts Customer,SFL or SEP,QTY,Stock Number(s),Order Number(s),Vehicle,Start Date,Customer Equipment,Package Number,Equipment Status,Ship Date Or Items We Are Missing,Pre Check,Pre Build,Lights Done + Harness Done,System Done ,Lightbar Color,Exterior Lighting,Push Bumper Or Lit Pus...

docs.google.com

 

[skillilea]

No worries. Hope it helped a bit.