Highlight Row Based on Cell Value

Use the formula =$G1=true if you are messing with Check Marks in the G Column - Otherwise it is =$G1="ValueToTrigger"

1. Create your table of data
2. Select your entire table of data
3. Click on "Format" and then "Conditional Formatting"
4. Create a new Conditional Formatting Rule
   1. Set the range to the table of data
   2. Change the rule to be "Custom formula is"
   3. Use the formula =$G1=true if you are messing with Check Marks in the G Column - Otherwise it is =$G1="ValueToTrigger"