Thread: Single cell to display red in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Single cell to display red in another cell
If you keep the concatenation a formula, then you can't do this.

Sheila wrote:

When concatenating cells 1-5, to appear in cell 6, how do I get cell 3 to
appear red (with all others black) in cell 6?

--

Dave Peterson
Reply With QuoteReply With Quote