Convert State abbreviations color coded cell
THanks!
"JE McGimpsey" wrote:
Hmmm... Given that there are 6 US time zones, that 14 states have more
than one time zone, that AZ doesn't change to DST, and that *parts* of
IN don't change, you may need to provide more info...
For a worksheet function/CF solution, create a table of states and
integers, then use VLOOKUP() in your CF.
Or you could use either a Worksheet_Change() or Worksheet_Calculate()
event macro
In article ,
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
|