Much more simple explanation of your needs and easy to do with CF.

See the other replies for the how-to.


Gord

On Thu, 1 May 2008 07:42:14 -0400, "Edward" wrote:

Thanks for responding.
I believe you're right. In my attempt to make it easier, I probably did
complicated it instead.
This is what I really need. Maybe this is actually easier:

Cell A5 would be the date that I placed an order.
Cell J5 would be the date that the order was completed.
If three days go by and the order has not been complete, I would like A5 to
change color to bring attention to the fact that a completed date has not
been entered in J5.

I've attempted this with conditional formatting and have had no luck.

Again, thank you very much for reading.