Hiding or Formatting non matching cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi!

One way:

Assume the dates are in the range A1:A31.

Since you only need to be concerned with the last 3 cells representing the
29th, 30th and 31st of the month:

Select the range A29:A31
Goto Format>Conditional Formatting
Formula Is: =MONTH(A29)<>MONTH(A$1)
Click the Format button
Set the font color to be the same as background color
OK out

Biff
 
Back
Top