How to set background color for a row based on cur

Question

I have a Google Docs SpreadSheet, where in the column A are dates (A1: 2013-11-22, A2: 2013-11-23, A3: 2013-11-24 etc). I would like to automatically highlight - set a background color for a row, where in the column A is today's date. To have every day a different row highlighted.

I expect that I will need a script, IMHO this is not possible to be done with conditional formating in Google Docs SpreadSheet.

Any idea how to do it? Thanks a lot!

Answer 1

This one is pretty simple.

Select the area it have to effect and Right click on the spreadsheet and select 'conditional format' From this menu select 'custom formula' (it might named different, but it's the last choice in the menu)

When a row need to be formatted when a cell in the column > 1, use this in the formula box

=$A$1:$A$100 > 1

Select the area you want to have effect like

A1:G100

that's it