View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HarrisonR HarrisonR is offline
external usenet poster
 
Posts: 2
Default how do I conditionally hide or show a column in Excel

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?