Thanks keithl816,

That's a start in the right direction. I put the condition "between" and gave the dates but the value doesn't change in format (I set the color to red). Is there something else I'm missing?

Also if anyone knows of a script or macro that I can run to pop up a notification box or play a sound file, that would be great too. Thanks for the help!