Perhaps you missed my answer to your post yesterday - here's a link to
it:

http://groups.google.com/group/micro...79ccaa0029693b

Hope this helps.

Pete

On Jul 12, 12:13*pm, Udayan wrote:
Any one could help me please.

I have a column (A1:A100) cells in date format and it calculate the date
with the current date and if it exceeds 365 days, the cell changes its colour
to red and if there is no date on the cell it remains the same color as it is.

=AND(TODAY()-A1335,A10)

The above thing working ok with the above formula.

Same is it possible to do with a group of columns with some other formula?,
ie., (A1:F100)

Thanks