Hi!

I'm having a hard time trying to figure out how you can enter a month and
year in a cell and then use a fomula like =K1+1 to get the first day of that
particular month/year.

But anyhow.......

Let's assume you enter a full date in K1: 12/1/2005, and that it's just
formatted to display as mmm-yy (or some format like that)

The easiest way I can think of to do this is to use conditional formatting
on the last 3 cells that represent the 29th, 30th and 31st of any month.

This requires that the Analysis ToolPak add-in be installed.

Create a named formula:

Goto Insert>Name>Define
Name: Lastday
Refers to: =EOMONTH(Sheet1!$K$1,0)
OK

Use your actual sheet name in that formula.

Now, select the last 3 cells that represent the 29th, 30th and 31st of the
month. I'll use cells K16:K18 in this example.

Select the range K16:K18
Goto Format>Conditional Formatting
Formula is: =K16>Lastday
Click the Format button
Set the font color to be the same as the background color.
OK out

Biff