Thanks Bob
Does everyone who uses this worksheet need to have the
addin or does it stay with the sheet.
Hope this makes sense.

Nick

-----Original Message-----
Take a look at the CFPlus addin at
http://www.xldynamic.com/source/xld.....Download.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nick" wrote in
message
...
I have a sheet where I enter different codes into the
cell. What I would like to do is when I enter a code the
cell background changes colour. There could be up to 10
codes so if I entered "AL" into a cell the background
could be RED or if I change the code to an "S" the cell
could be BLUE.
Is this possible?

All help appreciated

Nick



.