yogi_Conditionally Format Cells B2 To B For Names In Column A Matching List of Names In Cell B2 Of Sheet1

             Google Spreadsheet   Post  #1867

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-25-2014

post by  Travisneedshelp:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/jDfRUj8zZmQ
Conditional "if" function across multiple sheets please help me

Hello All, 

I'm not Excel or Sheet savvy enough to figure out the formula I need to complete this function. Basically I have a list of names separated by commas in
Sheet 1, cell b2. I then need a conditional formatting formula that will search this list of names in sheet 1; and, in sheet 2, insert the word "present" if a specific person's name appears in the list. If not, it should mark "absent." 

To be more clear, 

Names in Sheet 1 cell b2: Bob, Billy, Brandy, Brad, Sarah. 

List of individual names in sheet 2 will appear as such (in individual cells): 

Bob

Billy

Brandy

Brad

Sarah

Then in the cell adjacent to each name I need a formula to reference the list in sheet 1 and apply the present or absent conditional formatting. 

Please please help me. I've tried for hours but can't get anything to work

------------------------------------------------------------------------------------------------------------------