View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Cell Color Changes

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?