How to Highlight Rows Automatically Based on Checkbox in Google Sheets (Khmer)

Hello everyone! Today I show you how to insert checkboxes and automatically highlight entire rows in Google Sheets step by step with video tutorial in Khmer language.

If you track daily tasks, project status, or inventory list in Google Sheets, this trick will automatically change row color and strike through completed tasks whenever you click checkbox!

Step 1: Insert Checkbox in Google Sheets

1. Select cells where you want checkboxes (e.g. column A2:A10).
2. Click Insert menu on top bar.
3. Click Checkbox.

Now your cells have interactive checkboxes! When unchecked, cell value is FALSE. When checked, cell value turns TRUE.

Step 2: Highlight Entire Row Using Conditional Formatting

To make the whole row change color when checkbox is checked:

Step by Step:

1. Select your entire table range (e.g. A2:E10 or $A$2:$E$10).
2. Click Format menu ➔ select Conditional formatting.
3. Under Format rules ➔ click dropdown Format cells if... ➔ select Custom formula is.
4. Type this exact formula (assuming checkboxes are in Column A):

   =$A2=TRUE
   

   (Or simply =$A2)
5. Under Formatting style, choose fill background color (e.g. light green or light grey) and check Strikethrough text button.
6. Click Done.

Now whenever you check box in Column A, the entire row turns green instantly!

Step 3: Filter Checked Tasks to Separate List (Bonus Formula)

If you want to pull only checked/completed tasks into another table or sheet:

Option A: Use FILTER Formula

=FILTER(B2:E10, A2:A10 = TRUE)

Option B: Use QUERY Formula

=QUERY(A2:E10, "SELECT B, C, D, E WHERE A = TRUE", 1)

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to highlight rows automatically with checkbox in Google Sheets:

💡 Quick Tip:

• The Magic Dollar Sign ($): Remember to write =$A2=TRUE with dollar sign before column letter A! If you forget dollar sign (=A2=TRUE), Google Sheets will only highlight single checkbox cell, not whole row!
• Uncheck All Checkboxes Fast: Select checkbox column range ➔ press Spacebar key (or press Delete key) to uncheck all checkboxes in 1 second!
• Count Checked Tasks: Use =COUNTIF(A2:A10, TRUE) to calculate total completed items automatically!

📚 Related Resources

• How to Split Text in Google Sheets (3 Easy Methods)
• IF vs Equal vs EXACT Function in Excel
• How to Use Track Change and Comment in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know