View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default highlighting cells

Apply conditional formatting for the table, condition: cell value/ equals/
=$A$5

Regards,
Stefi


robbie ezt *rta:

Hi,
I have a tables of names, and I would like the name to be highlighted when
selected in a different cell,

example
table 1 in cells a1 john a2 jim a3 jayne
when cell a5 is equal to john, I would like john to be highlighted,
many thanks in advance