formula help

[Candace]

Please help me with a formula that does the following:

If the difference between the dates in column A and column B is greater than
30 days, then the fields in column C should be highlighted in yellow.

 

[John C]

Format|Conditional Formatting
Change drop down to Formula is:
In C2: =ABS(B2-A2)>30
choose your formatting.

 

[Mike H]

Hi,

You didn't say which was the later date so this assumes column B

Select c1 then
Format|Conditional format
Formula is
=B1-A1>30
Pick your colour
OK

Use the format painter to copy this down column C as required
Mike

 

[Candace]

Your assumptions are correct. However, would it be possible to highlight the
field itself, instead of changing the color of the text in the field? In most
cases there we be no text in column C yet. This spreadsheet is supposed to
alert a user to enter something in column C if the difference between column
A and column B is greater than 30 days.

 

[John C]

When you are picking your format, choose the Patterns tab, that is the
background color of the cell.