Thread: Trying to highlight cells that have the same value as the active c
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel_Rookie Excel_Rookie is offline
external usenet poster
  
Posts: 2
Default Trying to highlight cells that have the same value as the active c
I want to be able to highlight all the cells that have the same text as the
active cell?

So if I'm on G8 and that cell has the word Apples then I want to highlight
all the cells in the E1:E100 range that have Apples in the cell.

Reply With QuoteReply With Quote