Conditionally format a cell using a list of data defined in a rang

  • Thread starter Thread starter Chad Wodskow
  • Start date Start date
C

Chad Wodskow

Is it possible to conditionally format a cell using data defined in a range
on a seperat tab?

The data sheet information being pulled from the range, and i would like the
cells to change colors when certain data appears. The names in the list that
I would like to turn the different color totals around 30 names
Example:
Cell A1 is "Larry"
Cell A2 is "Bill"
Cell A3 is "Fred" - Any cell that contains Fred, Bob, or Frank turns yellow
Cell A4 is "Bob"
Cell A5 is "Frank"

Thank you
 
Back
Top