A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Color coding cells in Excel



 
 
Thread Tools Display Modes
  #1  
Old September 11th 05, 02:46 PM
jdiedrick
external usenet poster
 
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

Ads
  #2  
Old September 11th 05, 03:58 PM
Max
external usenet poster
 
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  
Old September 12th 05, 09:30 PM
David McRitchie
external usenet poster
 
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  
Old September 12th 05, 11:39 PM
Max
external usenet poster
 
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
--


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 18th 05 12:10 AM
How do I merge cells in Excel, like just 2 cells to make one big . chattacat Excel Discussion (Misc queries) 2 January 19th 05 05:25 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 10:21 PM


All times are GMT +1. The time now is 05:59 PM.


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