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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top