Hello from Steved

Thankyou.

"Ron Rosenfeld" wrote:

On Wed, 11 Jan 2006 16:01:02 -0800, Steved
wrote:

Hello from Steved

I have an 12 month excel calendar

I would like to have the last day of each month have a light yellow.

If this is possible how.

Thankyou.


You can use conditional formatting. "Formula Is:"

One formula that will return TRUE if the date in the cell is the last day of
the month is:

=MONTH(A1)<MONTH(A1+1)


--ron