Quday-Conditional Formatting

[Udayan]

I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow.

Highilighted the required cells (A1:A100) and Given formula in condition
formatting
=today()-A1>365

My problem is that the blank cells also showing RED colour.

I want to the blank cells as it is.

Kindly helpppppppppppppp meeeeeeeee

 

[Teethless mama]

=AND(TODAY()-A1>365,A1>0)

 

[Jarek Kujawa]

try

=IF(AND(NOT(ISBLANK(a1)),TODAY()-A1>365),1,0)

 

[Udayan]

Appreciate your quick reply.

Thanks you are a Gentle Man

Thank you very much............. for your great help

 

[Udayan]

It worked thanks,

If i want to do the same thing with a group of columns
for example (A1:F100)

will this same formula works

 

[Udayan]

Thanks it worked too