Highlighting an entire row

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Select all columns

Order of evaluation

• Left to right

• Down one row

• Left to right again

• Highlighted one cell at a time

Fixing column references

	A	B	C
1	12	22	8
2	21	7	2
3	=A1+A2	=B1+B2	=C1+C2
4	=$B1+$B2	=$B1+$B2	=$B1+$B2

   

Left to right

References move in row 3, stay the same in row 4

Fixing your formula

Time to try it out!

Conditional Formatting in Google Sheets