OmniDocConditional Formatting for Checkboxes and TRUE Values
Learn how to link a checkbox to a cell, write a formula rule that reads TRUE, and highlight whole rows when a box is ticked in a spreadsheet.
A task list with a checkbox on every row is easy to read until you want the finished items to stand out. Many people then search for a way to color a row when its box is ticked, or to show a check mark in a cell when a condition is true. The answer depends on one detail: a checkbox does not change the cell's color or content by itself. It writes a TRUE or FALSE value to a linked cell, and a conditional formatting rule has to read that value.
This article covers conditional formatting for check boxes in a spreadsheet, along with the TRUE and FALSE logic behind it. You will link each checkbox to its own cell, write one formula rule that works down the whole range, and test that the highlight follows the box. The method is general, so it works in any spreadsheet program that supports form checkboxes and formula-based conditional formatting.
How do you highlight a row when its checkbox is ticked? The short answer
Link each checkbox to a cell in the same row, then add a formula-based conditional formatting rule that tests that cell for TRUE.
| Your situation | What to do | Why |
|---|---|---|
| You want a whole row colored when its box is ticked | Select the row range, start the formula at the first row, and use =$C2=TRUE | The rule reads the linked cell in each row and colors the full row |
| You only want one cell highlighted | Select just that cell and use =C2=TRUE | A single-cell rule needs no column anchor |
| You want a check mark symbol in a cell | Use a helper column with =IF(C2,"✔","") and format that column | Conditional formatting changes colors and fonts, not the text itself |
| You are working with a PDF checklist instead | Use the PDF editor to fill forms, or sign the file | Forms and signatures are PDF tasks; they do not add conditional highlighting |
Before you start
Check these points before building the rule. Each one prevents a common reason the highlight fails to appear.
- Your checkboxes need a linked cell. A checkbox that is not linked to a cell has nothing for the rule to read. Give each one its own cell, such as a column of hidden TRUE/FALSE values or a visible status column.
- Decide the data range. Choose the rows that should be highlighted, for example A2 to E20 for a 19-row task list. The first row of the range matters because the formula is written relative to that cell.
- Turn on the developer tools if needed. Form checkboxes usually sit under a developer section that some programs hide by default. Enable it in the program's options before you look for the control.
- Know what the linked cell shows. A ticked box returns TRUE and a cleared box returns FALSE. Blank cells are not TRUE, so a rule using =TRUE will not highlight them.
- Keep the sheet structure stable. If you insert or delete rows, the checkbox links and rule ranges can shift. Check both after any large edit.
OmniDoc does not add checkboxes or conditional rules to spreadsheets, so the steps below use your own spreadsheet program. OmniDoc is useful for the related document work covered in the table above.
Linking checkboxes and writing the rule, step by step
- Plan the columns. Put the checkbox in one column, such as B, and the linked cell in another, such as C. Keep the linked column visible while you build the rule so you can see the TRUE and FALSE values.
- Insert a checkbox form control in the first data row. Use the developer section to add a checkbox, then place it over cell B2. Give it a short label such as "Done" or leave the label blank.
- Link the checkbox to its cell. Open the checkbox's properties and set its cell link to C2. Ticking the box now writes TRUE to C2, and clearing it writes FALSE.
- Repeat for every row. Give each checkbox its own linked cell in the same row, so B3 links to C3, B4 to C4, and so on. Copying the checkbox is faster, but confirm each copy has its own link.
- Select the range to highlight. Select the rows you want colored, starting at A2. For a task list, A2:E20 covers the label, the checkbox, and the linked cell columns.
- Create a formula-based rule. Open the conditional formatting options, choose the rule type that uses a formula, and enter =$C2=TRUE. The dollar sign locks the column to C, and the 2 lets each row point to its own linked cell.
- Choose a format and apply. Set a fill color or a font style that is easy to see but still readable. Apply the rule, then close the dialog.
Check the result
Once the rule is in place, test it with real clicks rather than assuming it works.
| Check | How to see it | If it's wrong |
|---|---|---|
| Linked cell value | Tick and clear a box, then look at its linked cell | If it stays blank, relink the checkbox to the correct cell |
| Highlight on the right rows | Tick the box in row 5 and confirm only row 5 changes | If other rows change too, the column reference is not anchored; add the $ before C |
| Highlight clears on FALSE | Clear the box and confirm the color disappears | If it stays, check that the rule is set to =TRUE and not =C2 alone |
| Rule order | Open the rules list and check which rules come first | Move the checked-row rule above any rule that sets a conflicting color |
| Range after edits | Insert a row and confirm the rule still covers the table | Edit the rule's applied range so it includes the new row |
If the highlight works in the first row but not below it, the likely cause is the row number in the formula. Click a lower row in the highlighted range and read the formula the program shows for it; the row number should match that row.
📊 At a glance
There are three common ways to show a checked state, and each suits a different goal.
| Method | What it shows | Good fit when |
|---|---|---|
| Row highlight with a formula rule | A colored row | You want completed tasks to stand out in a list |
| Cell highlight with =C2=TRUE | A colored single cell | You want one status column to flag progress |
| Helper column with IF | A text symbol such as a check mark | You need a visible symbol that can be copied or printed in black and white |
🎯 Which approach fits you?
- If you run a personal task list, link each checkbox, highlight the whole row, and keep the linked column visible for quick checks.
- If you share the sheet with others, use a helper column with a symbol so the status survives copying into a plain-text report.
- If your checklist lives in a PDF, use the PDF editor to fill form fields and sign the document. Conditional highlighting belongs in a spreadsheet, not a PDF.
❓ FAQ
1. Why does my rule color blank cells?
Usually the formula is written without the TRUE test, such as =$C2 alone, and a blank cell is treated as not-true in some programs but still triggers the rule in others. Use =$C2=TRUE so only a ticked box matches.
2. Can conditional formatting add a check mark symbol?
Not by itself. Conditional formatting changes colors, fonts and borders, but it does not write new characters. Put =IF(C2,"✔","") in a helper column, then apply formatting to that column if you want the symbol colored.
3. Why is my linked cell showing text instead of TRUE?
Some programs link the checkbox to a cell that is formatted as text, or the value was typed by hand as text. Clear the cell's contents, make sure the checkbox is linked to it again, and tick the box once to write a fresh TRUE value.
4. Does OmniDoc add checkboxes to spreadsheets?
No. The steps in this article use the spreadsheet program you already have. OmniDoc can help with related document tasks, such as filling a PDF form or signing a file, but it does not create conditional highlighting.
📝 Summary
A checkbox only records TRUE or FALSE in a linked cell, so the highlight depends on a formula rule that reads that cell. Link each box to its own cell, anchor the column with a dollar sign, and test by ticking and clearing every row. Use a helper column when you need a visible check mark.
