View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toto Sanderson
 
Posts: n/a
Default Change Cell Color when another cell is selected

Hi all,

I've been searching this group, couldn't find answers to my question below:

Row 1 is name of the places
Column A is dates of the year.

When a cell is selected in the area in the middle, I would like the place
name and date in Row1 and ColumnA to be highlighted as well.

I know there is a RowLiner that you can download and use, but it's not
really working. I guess it's because Row1 and ColumnA are splited and frozen
pane.

Anything that we could do in conditional formatting or even VBA?

Thanks in advance

Toto Sanderson