On Jul 11, 7:56 am, Rob wrote:
I tried that, but if I try to enter the formula it will be specific to
whichever row I enter, such as the 436 used in the formula, and I want the
formatting to reference the data in each row since the dates and thus the due
date will vary. Also, I tried entering the entire A column and F column, but
received an error. Thanks for the idea, though Spiky.


Hmm. It works properly in version 2003. Are you sure it kept the
absolute/relative references properly? It likes to assume all is
absolute in the conditional format window.

Also, you may not actually need the "IF". If possible, design a
formula that gives a TRUE to change the highlight color, then you have
fewer details.