Colour Rows subject to value in cell
| Category |
|---|
| Excel |
| Date Created |
| 21st Feb 2010 |
| Last Updated |
| 9th Jul 2010 |
Colour Rows subject to value in cell
Question
How to colour rows subject to value in cell?
Answer
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