Hi.
This is probably a very basic question, but as someone relatively new to the features available in Excel its one that is driving me mad.
I have a column with a combination of blank cells and dates (in a simple UK format, eg. 13/08/2012).
What I am trying to do is use conditional formatting to highlight just the dates in green if the date is after (ie a future date) tomorrow , and in red if the date is tomorrow, today or any date in the past.
I've tried looking on line, but have so far drawn a blank.
Any help would be appreciated, and then perhaps I can stop pulling what little hair I have left out!
Adrian
Bookmarks