On Nov 19, 7:47*pm, Gord Dibben <gorddibbATshawDOTca wrote:
First of all, you can't have more than one date in a cell unless you enter
them as text.

Are you saying A1 will have a varying date?

Do you want to format the various dates a different color?

If so, you make a rule for each Date.

If you want to format various dates to same color you could use the OR
function.

=OR($A1=DATEVALUE("12/25/2009"),$A1=DATEVALUE("12/31/2009"),$A1=DATEVALUE("1/7/2010"))

up to 7 dates.

Gord

On Thu, 19 Nov 2009 02:29:35 -0800 (PST), RedBeard wrote:
On Nov 18, 6:27*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Not sure what you mean.

Do you mean for the CFFormula is:?

Please give an example.

Gord

On Wed, 18 Nov 2009 04:55:39 -0800 (PST), RedBeard wrote:
Addendum, I got it working.

However, an additional question, how do I combine multiple dates in
the same formula?

I meant as following:

+ DATEVALUE("12/31/2009") + etcetcetc

Apologies for being unclear.

Unclear again, my mistake.
However, you provided me with the solution in #2 so I'm now sorted,
thanks for all the effort.