I have a column of dates ranging from blank to future dates. I want to apply conditional formatting based on comparison to today's date. I'm working in Office 2007.
Using the stoplight icons with the checkmark, exclamation point, and ex symbols, I want the following results:
Green: value >=...