How to colour the entire row using Conditional Formatting in Google Sheets?
So how to colour the entire row using conditional formatting in Google Sheets? Conditional formatting in Google sheets is pretty much the same as in the other popular spreadsheet program. Conditional formatting is pretty straightforward when you want to change the the same cell, but what if you want to be able to change the colour of the entire row based on the value of a single cell within that row then this tutorial is will show you how.
As a bonus I've also added how to create a drop down list which is a pretty cool way to change the values and get the colours to change dynamically.
#computertutoring
00:00 Introduction
00:51 Colour a whole row based on an entry
01:20 Using the $ sign
01:59 Type in formula
03:00 Create a drop-down list using data validation
03:45 Change conditional formatting
06:30 Expand the data
07:15 Add another conditional formatting rule