Hi, I have a spreadsheet of items that need to be watched for expiration....

Column E has the Expiration Date...

I need a formaula (I think for the conditional formating) to have the row
highlight when the it's 60 and 30 days to expiration.

I tried the =and(E1:E1000<"",today()-30)

It did not work....

Thanks any help would be appriciated.
--
Jules