Fill a cell in orange if the result is negative, help please.
 

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

Fill a cell in orange if the result is negative, help please.
 

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

Fill a cell in orange if the result is negative, help please.
 

Click on the first cell in Column 3 (C?)
Go to Format - Conditional Formatting
Condition One
Format Is
Then in next box put in this formula: If(Col1-C0l2 < 0, true, false)
(Substitute the col1 and col2 for A, B, or whatever)
Then click format, click Patterns tab and pick the color orange.

HTH
--
Sandy


" 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