I'm working on making a spreadsheet in Google Sheets, and I'm attempting to have a column of names and then a column of dates adjacent to it.
I'd like to set up some sort of conditional formatting that checks if a cell's date has past or not, and if it has, formats the corresponding cell in the name column with a strikethrough.
Names | Dates | Etc. Name Here | Date | --- Name 2 | Date2 | ---
So if the second date listed under "Dates" already passed (aka 1/10/16 as opposed to 2/19/16 compared to today's date, 1/19/16), then the second name listed under "Names" would appear formatted with strikethrough (like you had crossed it out).