9

Possible Duplicate:
Advanced date logic in Google Spreadsheets

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?

Improve this question
0

1 Answer 1

Reset to default
21

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
Improve this answer
1
  • 5
    If your answer points to another question on the site you should really be flagging as a duplicate.
    – ChrisF ♦
    Aug 1, 2012 at 16:32

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