software

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 Formatgt;Conditional Formatting
Formula Is: =MONTH(A29)lt;gt;MONTH(A$1)
Click the Format button
Set the font color to be the same as background color
OK out

Biff

quot;A.R.J Allan Jefferysquot; gt; wrote in
message ...
gt; Hello Again
gt; in column A i have 31 cells representing a 31 day month using tha =a2 1
gt; for
gt; all 31 days, but some months have less, so the eg: below is a pain to look
gt; at.
gt; Is there a way to make the non matching dates, to be not visible when the
gt; month changes.
gt;
gt; 27-feb
gt; 28-feb
gt; 1-mar
gt;
gt; Thanks again
gt; Allan
thanks Biff
It worked like a charm.
Regards Allan

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; One way:
gt;
gt; Assume the dates are in the range A1:A31.
gt;
gt; Since you only need to be concerned with the last 3 cells representing the
gt; 29th, 30th and 31st of the month:
gt;
gt; Select the range A29:A31
gt; Goto Formatgt;Conditional Formatting
gt; Formula Is: =MONTH(A29)lt;gt;MONTH(A$1)
gt; Click the Format button
gt; Set the font color to be the same as background color
gt; OK out
gt;
gt; Biff
gt;
gt; quot;A.R.J Allan Jefferysquot; gt; wrote in
gt; message ...
gt; gt; Hello Again
gt; gt; in column A i have 31 cells representing a 31 day month using tha =a2 1
gt; gt; for
gt; gt; all 31 days, but some months have less, so the eg: below is a pain to look
gt; gt; at.
gt; gt; Is there a way to make the non matching dates, to be not visible when the
gt; gt; month changes.
gt; gt;
gt; gt; 27-feb
gt; gt; 28-feb
gt; gt; 1-mar
gt; gt;
gt; gt; Thanks again
gt; gt; Allan
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;A.R.J Allan Jefferysquot; gt; wrote in
message ...
gt; thanks Biff
gt; It worked like a charm.
gt; Regards Allan
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; One way:
gt;gt;
gt;gt; Assume the dates are in the range A1:A31.
gt;gt;
gt;gt; Since you only need to be concerned with the last 3 cells representing
gt;gt; the
gt;gt; 29th, 30th and 31st of the month:
gt;gt;
gt;gt; Select the range A29:A31
gt;gt; Goto Formatgt;Conditional Formatting
gt;gt; Formula Is: =MONTH(A29)lt;gt;MONTH(A$1)
gt;gt; Click the Format button
gt;gt; Set the font color to be the same as background color
gt;gt; OK out
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;A.R.J Allan Jefferysquot; gt; wrote
gt;gt; in
gt;gt; message ...
gt;gt; gt; Hello Again
gt;gt; gt; in column A i have 31 cells representing a 31 day month using tha =a2 1
gt;gt; gt; for
gt;gt; gt; all 31 days, but some months have less, so the eg: below is a pain to
gt;gt; gt; look
gt;gt; gt; at.
gt;gt; gt; Is there a way to make the non matching dates, to be not visible when
gt;gt; gt; the
gt;gt; gt; month changes.
gt;gt; gt;
gt;gt; gt; 27-feb
gt;gt; gt; 28-feb
gt;gt; gt; 1-mar
gt;gt; gt;
gt;gt; gt; Thanks again
gt;gt; gt; Allan
gt;gt;
gt;gt;
gt;gt;