Prev: Report using dates as a criteria
Next: Cannot get the column to total with =sum
From: Chad Wodskow on 4 Mar 2010 12:09
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
From: T. Valko on 4 Mar 2010 12:30
What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Chad Wodskow" <ChadWodskow(a)discussions.microsoft.com> wrote in message
news:2B8E74A8-B178-47AE-91CE-0A942BC5884D(a)microsoft.com...
> 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


From: Teethless mama on 4 Mar 2010 13:04
=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
 | 
Pages: 1
Prev: Report using dates as a criteria
Next: Cannot get the column to total with =sum