Thread: Cond. format text color based on another's text color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
manxman manxman is offline
external usenet poster
  
Posts: 26
Default Cond. format text color based on another's text color
I want to copy text from A1 to C1, and if A1 text is red, then the copy
should be black(automatic), and vice versa. Can I do this in conditional
formatting, or do I need to go to VBA?
Reply With QuoteReply With Quote