Conditional formatting on GOOGLE SHEETS and NOT Excel. If "All Shipped" (P) Column is TRUE, clear formatting from A:J, add strike-through. If "All Shipped" (P) Column is TRUE but there is NO VALUE in "Ship QTY" (Q) and NO VALUE in "Packing Slip" (S) , then highlight Q and S in bright yellow to prompt the user to fill out that required information.
Solved by X. H. in 30 mins