|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?