I have a copy of a spreadsheet that changes cell colors when I type
particular words into that cell. There is no code listed in the function
line for me to replicate into a new worksheet.

What is the code for linking a particular color to a particular word and
where do I type it?

It is conditional formattimg.

Select one of the cells, and goto FormatConditional Formatting. You will
see there what is being tested.

--
__________________________________
HTH

Bob

"masweets" wrote in message
...
I have a copy of a spreadsheet that changes cell colors when I type
particular words into that cell. There is no code listed in the function
line for me to replicate into a new worksheet.

What is the code for linking a particular color to a particular word and
where do I type it?

Thanks! It sure cleared things up!

Mike

"Bob Phillips" wrote:

It is conditional formattimg.

Select one of the cells, and goto FormatConditional Formatting. You will
see there what is being tested.

--
__________________________________
HTH

Bob

"masweets" wrote in message
...
I have a copy of a spreadsheet that changes cell colors when I type
particular words into that cell. There is no code listed in the function
line for me to replicate into a new worksheet.

What is the code for linking a particular color to a particular word and
where do I type it?