I need to know a formula that will allow me to color cell A1 if J1 is between a date range, i.e. 01/01/11-12/31/11.

I have tried If, IfS, Not, And, and Date. So far, I am not speaking the language required.

Thanks