yogi_Conditionally Format Cells E7 To EY33 If Entry In Column E is 'Complete' and Entry In Column F Through EY is 'X'