Thursday, July 18, 2013

Google Spreadsheet Change Cell Color If Cell Contains Todays Date

Change the background color or the font color of the cell if it has today's date:

Go to "Format" > "Conditional formatting..."




And then select "Date" and "today" set the text color or background color to whatever you prefer.




I hope this helps.

1 comment:

  1. This is very close to what I want to do, but I don't want just the cell containing the date to be affected, I want the entire row to change.

    ReplyDelete