Google Sheets Conditional Formatting

Have you ever wanted to highlight an entire row based on the value in one cell of that row? Now you can using Conditional Formatting in the new Google Sheets!

1. Select entire sheet
2. Go to: Formula > Conditional Formula > Custom Formula is
3. In the first box, put your cell argument (ie. =$C2<80) Be sure to put the "$" sign in front of the cell for the absolute reference.
4. Choose the background color
5. Choose the range (entire sheet) (ie. A2:C21)
6. Click on Save rules