yogi_Apply Conditional Formatting -- Starting With Row 2 Column B If A Name Does not appear In Previous Column(s) Change Its Font Color To Red

                                         Google Spreadsheet   Post  #1605
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-16-2014
post by BryanP -- question by mikael3: (https://productforums.google.com/forum/#!mydiscussions/docs/OsjqOTXZQl4)
New Conditional Formatting option - Custom formula is

Hi,

Hoping someone can help whether custom conditional formatting is possible for something like this.

thank you

I have a spreadsheet where I have different names listed by column.

Everday I'll have new columns of names.

I want to be able to change text of a name that is not in previous columns to red.

example:

A       B      C        D

Bob   Mike   Bob   John

John  Bob    Dee    Chris

Will   John   John    Will

Kay   Will    Kay    Kay

So column B would have Bob text change to red

Column C,   Dee would change to red text

Column D,  Chris text would change to red,

etc....

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