View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
manxman manxman is offline
external usenet poster
 
Posts: 26
Default Copy text cell & change text color conditionally

I want to copy text from cell A1 to cell C1, and if the text in A1 is red,
make C1 black, and vice-versa. There is no formula in A1.