Hi,

I have a column for each month where the dates are entered on rows. Is
it possible I can color a cell if the date entered in a cell for that
month is 15 days past the end of the month. Like, if in a January
column I enter a date on one of the rows as Feb.20, then the cell
fills with red colour.

I tried doing it using conditional formatting, but don't know how to
say 15 days past end of the month?

Any help will be appreciated! Thanks very much!

Shivam

Hi Russell,

I tried that (in 2003) and it works, but the thing is, the date in my
column is
entered automatically by a macro (upon entering data in the cell to
it's left)...so even though I put a conditional format on the cell,
after the date is entered by the macro, it didn't change colour.

So, is it possible to use a macro that can look in a column and then
colour a date if it is 15 days past the end of the current month?

Thanks for all your help!

Shivam
> > .