Microsoft Excel - Conditional Highlighting Formula
I want to be able to compare 2 existing date columns and then flag/highlight a celll that shows a difference in dates of 10 days or less. The goal of this exercise is to easily identify projects where the due date is in jeopardy. If there's another method to managing this on dozens of projects where the source data can change and/or new projects be added, I would love advice (and a formula) to easily implement.
Thank You in advance!!!!!!
**
In my spreadsheet, I have 2 columns:
Column E (Order Date) (MM/CC/CCYY format)
Column F (Due Date) (MM/CC/CCYY format)
Is there a formula that will highlight the due date column with a specific color (say red) IF the difference of the order date and due date is 10 days or less (also accounting for January order dates and February due dates)?
3 examples below:
In this example, the 'due date' is 11 days difference from the order date. The due date would not be flagged (or made red).
Order Date = 01/15/2016
Due Date = 01/126/2016
In this example,the order date and due date is less than 10 days apart. I want the 'due date' column to flag the cell red to alert me.
Order Date = 01/28//2016
Due Date = 02/05/2016
In this example,the order date and due date is less than 10 days apart. I want the 'due date' column to flag the cell red to alert me.
Order Date = 01/14//2016
Due Date = 01/23/2016
I want to be able to compare 2 existing date columns and then flag/highlight a celll that shows a difference in dates of 10 days or less. The goal of this exercise is to easily identify projects where the due date is in jeopardy. If there's another method to managing this on dozens of projects where the source data can change and/or new projects be added, I would love advice (and a formula) to easily implement.
Thank You in advance!!!!!!
**
In my spreadsheet, I have 2 columns:
Column E (Order Date) (MM/CC/CCYY format)
Column F (Due Date) (MM/CC/CCYY format)
Is there a formula that will highlight the due date column with a specific color (say red) IF the difference of the order date and due date is 10 days or less (also accounting for January order dates and February due dates)?
3 examples below:
In this example, the 'due date' is 11 days difference from the order date. The due date would not be flagged (or made red).
Order Date = 01/15/2016
Due Date = 01/126/2016
In this example,the order date and due date is less than 10 days apart. I want the 'due date' column to flag the cell red to alert me.
Order Date = 01/28//2016
Due Date = 02/05/2016
In this example,the order date and due date is less than 10 days apart. I want the 'due date' column to flag the cell red to alert me.
Order Date = 01/14//2016
Due Date = 01/23/2016