how do I conditionally hide or show a column in Excel

[HarrisonR]

Version = MS Excel 2003
I'm setting up a generic worksheet to be used for any month of any year. I
have thirty one columns for the days. I want to hide the 'extra' days to
deny my users access to those columns. Can Conditional Formatting be applied
to the columns so that they are hidden, or the widths set to zero?

 

[Dave Peterson]

You can't hide columns or rows using conditional formatting.

If you have to use conditional formatting, you could use a white font on white
fill to "hide" the contents.

But you can hide the columns yourself--just rightclick on the column header and
format|Column|hide.

You may want to unlock the cells that that users can change, then protect the
worksheet. It's not very secure, but will stop lots from trying to unhide those
columns.

 

[HarrisonR]

Thank you, Dave,

I expect the only way to achieve what I want is to use a macro triggered by
altering the 'key' date field. I can't see myself going to each user and
manually hiding the extra columns whenever they open the template!

HarrisonR