If you are trying to reply to someone's answer to your question, you need to
reply to that message, not to your original question, and you need to ensure
that the relevant part of the reply is quoted, so that we can see what it is
to which you think you are replying.

As it is, we haven't a clue what you're talking about.
--
David Biddulph

Mark wrote:
David, that worked fine also, except it turned the cell C7 when I
emptied C6.

Is there a way to keep it white.

I have two conditionals for C7
1. if less than 1 pattern white
2. If greater than or equal to pattern red

I want it white until Condition 2 with your formula

Thanks.

Mark

"Mark" wrote:

Across the columns there are projected dates in row C5
C6 is empty, but "will" contain Actual dates

C7 is =C6-C5 formatted to number

My problem or question is without and "Actual" date in C6
I get a "numerical date" in C7 ,
because it is calculating C6 against C5.
thus rendering C7 with a numerical value of C5.

Is it possible to have C7 (with the formula)stay blank or white
until and actual date is placed in C6?

Thank you once, again, and for the numerous helps today.

Mark