View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SJT SJT is offline
external usenet poster
 
Posts: 71
Default Conditional Formatting/Array Formula

I have a range of cells (A1:A20) that contains either text string A or text
string B. I would like to write a formula that looks at the entire range and
changes text string B to text string A automatically. Can I do that? Thank
you in advance for your assisteance.