On Wed, 18 May 2005 03:26:05 GMT, "Jerry Kinder"
wrote:

Col A is Jan, Col B is Feb, etc. to Dec.

in A2 is 1 Jan in B2 is 1 Feb and so on.

I want to drag down from row 2 to 32 but want each month to stop displaying
dates when the end of each Month comes. Jan has 31 days and Feb has 28 so
Feb will display nothing in the last few cells not start with March.

I use =A2+1 in A3 etc. across the top and drag all columns down at one time
so I do not have to do each column one at a time.
Thanks,
JK





Select the range A3:L32
Format/Conditional Formatting
Formula Is: =MONTH(A3)<MONTH(A$2)
(note the "$" in the last function)
Format/Font Color "White"
OK/OK



--ron