In the third column enter the formula shipping date - required date so
if your data is in columns A and B starting in row 2 in C2 enter
=A2-B2.
Copy this formula down and format all the cells as General.
Then select all the cells in column C containing the formula and from
the Menus select FormatConditional Formatting.
Enter the condition that Cell Value is Less than 0 and set the required
formatting.

Hope this helps
Rowan

wrote:
Hello,

I have a form with 3 columns:
1 is for the required date
the second is for the shipping date
I have about 200 items in rows.

In the third column I want to calculate the delay: shipping date -
required date
and if the result is negative I want fill the cell in orange.

Do you have an idea?

Thank you for your help.
Regards,

Thierry