Pages

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