Or just

=VLOOKUP(A1,$G$1:$I$50,3,FALSE)=1


--


Regards,


Peo Sjoblom




"Luke M" wrote in message
...
To expand on Gary's reply, you conditional format would be

Formula is: =IF(VLOOKUP(A1,$G$1:$I$50,3,FALSE)=1,TRUE,FALSE)

Where A1 is the cell the format is appied to, and G1:I50 is your vloopup
table.

Also, conditional formats have a limit of 3. (annoying) You could get
around
this by making the default background one of the colors you want. Then the
conditional format will change all the others.
--
Best Regards,

Luke M


"Gary''s Student" wrote:

Normally you could create a lookup table with state abreviation in one
column
and zone in the adjacent column. You caould then apply conditional
formatting based upon a simple VLOOKUP equation.

Problem is that some states are in two zones. States like:

Idaho
Kansas
Kentucky
etc.
--
Gary''s Student - gsnu200760


"exceluser" wrote:

I would like to take fifty state abbreviations, divide into 4 times
zones
each with each zone (with multiple states) having its own color. For
example,
anytime Excel sees CA,NV,OR,WA it colors the cells red. If it sees TX,
OK,
MO, AL, WI etc it colors the cells green. Yellow for east coast, etc.
The
only way I could figure to do this was to convert the text to numbers
then
use conditional formatting but didn't see a function that would work on
state
abbreviations. Thank you