Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
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?

share|improve this question

marked as duplicate by ChrisF Aug 1 '12 at 16:32

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 7 down vote accepted

Similar to this question, you'll want to use conditional formatting.

  1. Select the cells and select Format > Conditional Formatting
  2. Select "Date is" "today" and select a Background colour
share|improve this answer
If your answer points to another question on the site you should really be flagging as a duplicate. – ChrisF Aug 1 '12 at 16:32
Thanks for the answer. That worked. Thanks!!! – daviesgeek Aug 1 '12 at 16:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.