Cell Color Changes

[masweets]

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?

 

[Bob Phillips]

It is conditional formattimg.

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

 

[masweets]

Thanks! It sure cleared things up!

Mike

It is conditional formattimg.

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

--
__________________________________
HTH

Bob