Teresa,

The closest you could come using Conditional Formatting to hide stuff would
be to turn it white (the column would look empty) (I know, it's a crummy
solution). Conditional Formatting won't hide columns. An event-fired macro
could do it.
--
Earl Kiosterud
www.smokeylake.com

"Teresa" wrote in message
...
I would like to set a conditional formatting that hides the first column of
my spreadsheet when a certain date expires. In addition I would like to
add
another column in the back off all others at the same condition.