I would like to format a certain column, meaning for example the 5th column
from the left to be seen. This should not automatically be the E-column!! If
for example the B and C column are hidden, I want the format to be for the
G-column. Does anybody have an idea how to do that??

Thanks,

Teresa,

By "format," you mean use a certain fill color, or something like that (the
Excel meaning of "format")? If so, a macro will have to do it if columns
are being hidden and unhidden, deleted and inserted, and the formatting must
change dynamically.
--
Earl Kiosterud
www.smokeylake.com

"Teresa" wrote in message
...
I would like to format a certain column, meaning for example the 5th column
from the left to be seen. This should not automatically be the E-column!!
If
for example the B and C column are hidden, I want the format to be for the
G-column. Does anybody have an idea how to do that??

Thanks,