highlight a row in Google Spreadsheet12 Jan 2017
I’m in the midst of coming back from an amazing trip around the world and now am in the process of getting a rental, buying a car etc. etc.
Anyway, my partner and I organise things through Google Spreadsheets, and it’s nice to be able to see who is assigned what with colour.
To do that in Google Spreadsheets
- Make a status column (e.g who something is assigned to), use Data Validation on that cell.
- Go to Format -> Conditional Formatting
- In Apply to Range put in
A1:Y98(which is a box from cell A1 to Y98, if you have more make the numbers larger)
Custom Formula Isfrom the dropdown.
=INDIRECT("C"&Row())="Completed"into the box. Now, in here,
Cis the column where my status cell is, and
Completedis the value I am after
- Choose your highlighting.
Bob is your veritable uncle.