Wednesday, April 16, 2014

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....
-------------------------------------------------------------------------------------------------------------------------------------------------