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

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
conditionally formatting 3
conditionally format cell in a range, based on value in other rang 4
Sum of Variable Cells in a fixed Row 3
conditional format of entire row based on a single cell in row 7
using a defined Name in a function 2
*Issue* Concatenate dates in a large range of cells in a row. 5
Dynamic pointing to a cell 0

Top