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