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

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Chad Wodskow" wrote in message
...
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

=OR($A1="Fred",$A1="Bob",$A1="Frank")


"Chad Wodskow" wrote:

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