Conditional formatting between two dates in Excel.

July 3, 2012 at 14:36:24
Specs: Windows 7
I have a conditional formatting question. I need to compare dates and depending on the result, come back with the correct formatting. This will be using three possible columns including Due Date, Revised Due Date, and Done Date.

For example, if a project is logged as being due on 6/9/12, and the done date is 6/9/12, I want to format the cell to have a green background. Or, vice versa if the done date is after the due date I want the cell to automatically format with a red background.

I also need to account for if the done date matches the revised due date but not the original due date.

Is something like this even possible?

See More: Conditional formatting between two dates in Excel.

Report •

July 3, 2012 at 15:34:59
Have you tried using the greater than, less than and equal operators to compare the dates? All you are looking for are formula that return TRUE when your conditions are met. Whenever the formula returns TRUE, the CF will be applied.



Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question