thanks a lost , it works
but for more clarification the B1 is the cell for €œLast working Day Date€�


"Roger Govier" wrote:

Hi Jon

Mark the range of cells you want to apply the CF to.
FormatConditional Formattinguse dropdown for Formula is
=AND($B1<"",TODAY()-$B10)
Choose Format you require.


--
Regards

Roger Govier


"Jon" wrote in message
...
Hi,
I have a sheet for tracking vacation plan. In this sheet I want to
make a
conditional formatting. The sheet contains three columns, the first
one is
employee name, and the second one is last working day, the third one
is
return to work. I want to apply specific conditional formatting on the
three
columns by special conditional as follows:
If the last working day date is over due itself, the all columns to be
filled with color automatically.
Your help is highly appreciated