Treesh1994
New Member
- Joined
- Aug 15, 2023
- Messages
- 45
- Office Version
- 2019
- Platform
- Windows
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.
docs.google.com
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...
