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
|