Auto Formatt Rows?

W

wx4usa

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
 
B

Bernard Liengme

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
 
R

Roger Govier

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)
 
Top