Hi Shivam

I don't know and wouldn't pretend to have a clue. Bowled me a googly in
cricketing parlance! (Nothing to do with search engines!)

I think you would be best posting your new question in general questions so
that it can be revisited. As you know the stumbling block here now is the
macro or how the data originates. I doubt whether this thread would be picked
up because it's a couple of days old.

If there is a way I'm sure one of the experts will be able to assist.

Regards

Russell

--
Russell Dawson
Excel Student


"Shivam.Shah" wrote:

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
.

.