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

First there is 365 days in a year not 335 (see your formula)

I think you are using conditional formating. To copy the conditional
formating

1) hight the cell with the conditional formula
2) Select the cells you want to copy the formula to
3) Use pastespecial (right click cells selected) and select FORMAT.

"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

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