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

Hiding or Formatting non matching cells
 

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 FormatConditional 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

"A.R.J Allan Jefferys" wrote in
message ...
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

Hiding or Formatting non matching cells
 

thanks Biff
It worked like a charm.
Regards Allan

"Biff" wrote:

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 FormatConditional 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

"A.R.J Allan Jefferys" wrote in
message ...
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

Hiding or Formatting non matching cells
 

You're welcome. Thanks for the feedback!

Biff

"A.R.J Allan Jefferys" wrote in
message ...
thanks Biff
It worked like a charm.
Regards Allan

"Biff" wrote:

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 FormatConditional 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

"A.R.J Allan Jefferys" wrote
in
message ...
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