No reason why it shouldn't work for you unless the source dates in B3:B5 are
not real dates recognized by Excel.

Note that formatting in itself doesn't convert text dates to real dates. You
can use Data Text to Columns to convert. Select the range of dates, eg
B3:B5, then click Data Text to Columns. Click Next Next. In step 3 of
the wiz., check Date under "Column data format", then select the appropriate
date format from the droplist, eg: DMY, and click Finish.

Here's a sample which illustrates the CF set-up (working, of course):
http://www.savefile.com/files/723204
CF_Dates_Traffic Lights.xls

Let me know here how it went for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Potaroo" wrote in message
...
Oh Max, it didn't work ;-(
Checked, made sure that the cells were formatted the same, ie "Number"
"Date" 08-Jun-07" etc, but to no avail.