View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cat Woman Cat Woman is offline
external usenet poster
 
Posts: 1
Default Click a cell and all related cells are colour highlighted

In a table I would like to click on a text item in first column and all text
cells that are related to this item would appear highligted in, say, yellow.
Procedure able to be repeated for any item in first column.

I am Excel beginner so if anyone knows how to do this, step by step
instructions would be great. Thank you.