I have a column of cells with dates in, is it possible for the individual
cells to change colour once that date has passed, to highlight them to me?

any help greatfully received!

hi

can you use conditional formatiing, which is available in the Format menu.

Regards,
Pugalzhenthi .V
--
______________
Regards,
Pugal.
______________


"hawkwood" wrote:

I have a column of cells with dates in, is it possible for the individual
cells to change colour once that date has passed, to highlight them to me?

any help greatfully received!

Yes, using conditional formatting. Take a look at
http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"hawkwood" wrote in message
...
I have a column of cells with dates in, is it possible for the individual
cells to change colour once that date has passed, to highlight them to me?

any help greatfully received!

It certainly is, use conditional formatting, select A1:-

format|conditional formatting|formula is

=A1TODAY() and then select a colour.

Mike

"hawkwood" wrote:

I have a column of cells with dates in, is it possible for the individual
cells to change colour once that date has passed, to highlight them to me?

any help greatfully received!