Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 05, 02:46 PM
jdiedrick
 
Posts: n/a
Default Color coding cells in Excel


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


  #2   Report Post  
Old September 11th 05, 03:58 PM
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



  #3   Report Post  
Old September 12th 05, 09:30 PM
David McRitchie
 
Posts: n/a
Default

I would expect if it take three letters do describe the color that
a choice of more than 3 colors (and 1 default) is wanted.

The normal solution is to use the change event for changes
that are typed in constants (not formulas). see
http://www.mvps.org/dmcritchie/excel/event.htm#case

For those that would rather use an addin that extends the limit
of 3 Conditional Formatting conditions per cell you take a look
at CFPlus - Extended Conditional Formatter, Bob Phillips
http://www.xldynamic.com/source/xld.....Download.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Max" wrote in message ...
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





  #4   Report Post  
Old September 12th 05, 11:39 PM
Max
 
Posts: n/a
Default

"David McRitchie" wrote:
I would expect if it take three letters do describe the color that
a choice of more than 3 colors (and 1 default) is wanted ..


Good additions, thanks. Guess I was so mesmerised by the magical number 3
in the OP's "3 letter codes" that I took it to mean there were only 3 codes
involved (besides each code having 3 letters, that is) <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL, VSTO: Fastest way to access multiple cells Alan Excel Discussion (Misc queries) 1 June 1st 05 02:45 PM
How can I have excel search and add multiple cells to find a targe Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM
Excel cannot shift nonblank cells Mr. Maz. Excel Discussion (Misc queries) 2 March 17th 05 11:10 PM
How do I merge cells in Excel, like just 2 cells to make one big . chattacat Excel Discussion (Misc queries) 2 January 19th 05 04:25 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 09:21 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017