Auto Formatt Rows?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wx4usa - 03 Jan 2007 16:53 GMT

I have a report that is layed out calendar style. By this I mean there
are 31 rows of data about 20 columns wide.

QUESTION: Is there a way to hide entire rows number 29, 30 and 31 in
February and row 31 in April, June, September and November based on the
month reviewed which is in cell a1?

Thanks

Reply to this Message

Bernard Liengme - 03 Jan 2007 17:31 GMT

Perhaps you could use Conditional Formating to make the text invisible (same
colours as background)
Here is an example for Row 31
Formula IS: =OR($A$1="Feb",A1="Apr",A1="Jun", A1="Sept",A1="Nov")
Font White and Pattern White
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have a report that is layed out calendar style. By this I mean there
> are 31 rows of data about 20 columns wide.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Roger Govier - 03 Jan 2007 17:32 GMT

Hi

Mark the whole of rows 29,30 and 31
Format>Conditional Formatting>choose Formula Is from dropdown
=ROW(A29)>DAY(DATE(YEAR($A$1),MONTH($A$1)+1,0))
Format>Font>White (or same colour as cell background)

Signature

Regards

Roger Govier

>I have a report that is layed out calendar style. By this I mean there
> are 31 rows of data about 20 columns wide.
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Rate this thread: