I'm trying to set up conditional formatting to show buttons (dots) comparing dates.
Let's say I have a target goal date - 10/9/2009. The actual date of the occurence was 10/12/2009 (so we're off by 3 days.) I want to set up conditional formatting so that anything below or at the goal date comes up with a green button, anything 1-3 days after the goal date shows with a yellow button, and anything 4+ days shows with a red button.
How do I do this?
Let's say I have a target goal date - 10/9/2009. The actual date of the occurence was 10/12/2009 (so we're off by 3 days.) I want to set up conditional formatting so that anything below or at the goal date comes up with a green button, anything 1-3 days after the goal date shows with a yellow button, and anything 4+ days shows with a red button.
How do I do this?