Hi Ron,
Sorry I get nothing from this. I do not understand how this works.
JK
"Ron Rosenfeld" wrote in message
...
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
|