Conditional Formatting - date ranges

A

Angela

How do I make cell colors in a column change if time between dates in
preceeding column exceeds 2 weeks? What is the formula for this?
 
A

Angela

Sorry if this was unclear - I want to create a condition where the
spreadsheet flags any dates in Column D if they exceed 14 days based on the
corresponding date in Column C. I want the cell color to change to red when
the two week deadline is missed. Can this be done??
 
B

Bob Phillips

Use a conditional formatting formula of =B1-A1>14

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
F

FinRazel

Assume A is your early date column, and B is your later date column.
Go to conditional formatting for column C.
For Condition 1, change the dropdown menu from "Cell Value Is" to "Formula
Is".
Paste this: =B1-A1>14
Apply the formatting you want.
And you're good to go.
 
Top