V
VanVonVen
Having data in few columns I want to do something similair to conditional
formatting.
Let's say that in column A I have data concerning people's names.
I want to change data in columns located far away from column A, e.g in
column Z (There I will insert people's addresses).
So the best way to see column A is to freeze part of table in the way that
i could see the first column.
Is it possible to make cells change (exactly: change the text in the cell,
by bolding it or inserting background) when they will "feel" cursor in the
other in the same row?
Summurizing: when I will be inserting adress in cell Z5, is it possible
that cell A5 will change (e.g. the text in that column will be bolded and
uderlined) till cell Z5 is active?
If it is possible must it be done in VBA?
Can anybody do this for me?
formatting.
Let's say that in column A I have data concerning people's names.
I want to change data in columns located far away from column A, e.g in
column Z (There I will insert people's addresses).
So the best way to see column A is to freeze part of table in the way that
i could see the first column.
Is it possible to make cells change (exactly: change the text in the cell,
by bolding it or inserting background) when they will "feel" cursor in the
other in the same row?
Summurizing: when I will be inserting adress in cell Z5, is it possible
that cell A5 will change (e.g. the text in that column will be bolded and
uderlined) till cell Z5 is active?
If it is possible must it be done in VBA?
Can anybody do this for me?