Hiding or Formatting non matching cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

A.R.J Allan Jefferys - 09 May 2006 00:39 GMT

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

Reply to this Message

Biff - 09 May 2006 02:31 GMT

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

> Hello Again
> in column A i have 31 cells representing a 31 day month using tha =a2+1
[quoted text clipped - 10 lines]
> Thanks again
> Allan

Reply to this Message

A.R.J Allan Jefferys - 10 May 2006 13:12 GMT

thanks Biff
It worked like a charm.
Regards Allan

> Hi!
>
[quoted text clipped - 28 lines]
> > Thanks again
> > Allan

Reply to this Message

Biff - 10 May 2006 18:30 GMT

You're welcome. Thanks for the feedback!

Biff

> thanks Biff
> It worked like a charm.
[quoted text clipped - 35 lines]
>> > Thanks again
>> > Allan

Reply to this Message