conditional formatting with specific date

I've been stuck on this for days now, so hoping someone would be able to assist with what I'm attempting to accomplish.

i have a cell, in which the data being entered into it will constantly be changing. However, there is a specific cut off date, that if its prior to that date we are able to skip certain steps and obviously anything after we must complete additional steps.

Through conditional formatting I am attempting to black out a different cell if the date entered (in another cell) is prior to 10/01/2012.

So for example:

A2 - is the cell used to input the always changing date
A10 - I want to either black out or remain unfilled depending on if the date in A2 is prior or after 10/01/2012

Select cell A10, click on Conditional Formatting | New Rule | Use a formula... from the bottom of the list, and then put this formula in the dialogue box:

=AND(A2<>"",A2<DATE(2012,10,1))

Then click on the Format button, Fill tab and choose black. Then OK your way out.

Hope this helps.

Pete

Hi Pete,

Just tried your formula and it works, so thank you for that so much!