Advanced date logic in Google Spreadsheets
Here's the problem. I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 to be highlighted if today is 7/30/2012 and Cell2 to be highlighted if today is 7/31/2012. How can I do this?