View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

One way via conditional formatting

Assume the 3 letter codes a ABC, DEF, GHI

Press CTRL+A (Selects the entire sheet)

Click Format Conditional Formatting
and set for Conditions 1 to 3, the "Formula Is:"
=ISNUMBER(FIND("ABC",A1))
=ISNUMBER(FIND("DEF",A1))
=ISNUMBER(FIND("GHI",A1))
Format to taste the fill color for each of the 3 conditions, OK out

Note: Replace FIND with SEARCH in the cond format formulas above
if case sensitivity for the 3 letter codes is not important
(FIND is case sensitive)

Adapt to suit ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"jdiedrick" wrote
in message ...

I have 3 letter codes that I would like to color code so that whenever I
type those 3 letter codes anywhere in the spread sheet the cell changes
to the color assigned to that specific code. How do I set this up?


--
jdiedrick
------------------------------------------------------------------------
jdiedrick's Profile:

http://www.excelforum.com/member.php...o&userid=27125
View this thread: http://www.excelforum.com/showthread...hreadid=466609