Colour Rows subject to value in cell

1. Select whole spreadsheet

2. Format > Conditonal Formatting

3. Select "Formulae Is"

4. Enter: =INDIRECT("J"&ROW())=0. This will apply selected format subject to value in cell J equalling 0.

You might like to refer to: http://www.asap-utilities.com