View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
A.R.J Allan Jefferys
 
Posts: n/a
Default Hiding or Formatting non matching cells

Hello Again
in column A i have 31 cells representing a 31 day month using tha =a2+1 for
all 31 days, but some months have less, so the eg: below is a pain to look at.
Is there a way to make the non matching dates, to be not visible when the
month changes.

27-feb
28-feb
1-mar

Thanks again
Allan