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?
--
AP - AGP Prod Dev
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??
--
AP - AGP Prod Dev
"Angela" wrote:
> 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?
> --
> AP - AGP Prod Dev
Use a conditional formatting formula of =B1-A1>14
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Angela" <Angela@discussions.microsoft.com> wrote in message
news:3508FAFD-8387-4AE2-9F65-1BB1E61789D3@microsoft.com...
> 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?
> --
> AP - AGP Prod Dev
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.
"Angela" wrote:
> 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?
> --
> AP - AGP Prod Dev
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??
--
AP - AGP Prod Dev
"Angela" wrote:
> 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?
> --
> AP - AGP Prod Dev
Use a conditional formatting formula of =B1-A1>14
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Angela" <Angela@discussions.microsoft.com> wrote in message
news:3508FAFD-8387-4AE2-9F65-1BB1E61789D3@microsoft.com...
> 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?
> --
> AP - AGP Prod Dev
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.
"Angela" wrote:
> 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?
> --
> AP - AGP Prod Dev
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks