Alert when a date is reached?

Hey guys, im an absolute n00b at scripting and coding, so im wondering if this is possible in an excel sheet at a basic level;

I have a list of say 200+ Servers with the manufacturer warranty expiry dates of all sorts (expired, and expiring, etc) on another column

I want a column where it looks at say CELL1 - TODAY and then either sends me an email when its 30 days short of today (i.e expires in 30days)

is it possible?

I'm not sure about the e-mail thing, but would just changing the color of the cell that is about to expire help? You can easily do that using Conditional Formatting.