Question:
How to 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
Taxonomy: