yogi_Conditionally Format Names Of Players In Column O That Have Been Drafted (per list in column Z) : Sheet1