Suppose today is 13 October 2015. I want to apply conditional formatting rules to four cells in Google Sheets:
10/22 Remove cat from bookcase
10/23 Put books back
10/24 Repair bookcase, 11/2 Send cat to vet
12/6 Sell cat
Cell 1 should be formatted one way ([first] date is before today), Cell 2 should be formatted a second way ([first] date is today), Cell 3 should be formatted a third way (first date is tomorrow) and Cell 4 ([first] date is not within the last week, today nor tomorrow).
How do I do this?