View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Conditional Formatting Based of Cells Based on Data Entry in anoth

I would like to type in data in one cell that would change the cell color of
other cells that match the data in the 1st cell. I.e. Typing XXX in Cell A1
would highlight all cells with XXX in them. Is that possible in Excel 2003?