Numbers. How to check a checkbox and make the text on that line change color

Hi gonzalezd,

Welcome to Apple support Communities, and the Numbers for Mac community.

What you've posted here regarding conditional highlighting is TRUE, and does what you say it will, but it doesn't answer the OP's question:

"How do i make it so when i check a checkbox and make the entire text on that line change color"

The three responses made (in 2012, when the question was 'fresh' and applied to the then current version of Numbers) all address applying formatting to "that line," two of them to highlighting using fill colour for the cells in the line, the other for changing the text colour in (one cell of) "that line."

What you've suggested will change only the fill colour of the checkbox cell.

Conditional highlighting rules compare the content of the cell they are applied to with a fixed value contained in the rule (as in your example "text is TRUE") or with the value in another cell.

The OP wants to apply the conditional highlighting to "the entire text on that line." That cannot be done setting a rule for the checkbox cell—the rule must be set for the cell(s) containing "the entire text on that line," and it must compare the content of that cell (or those cells) with a fixed value or with the content of another cell.

The two solutions above using colour fill rather than text colour change will also work in the current version of Numbers, and will provide formatting that appears to have been applied to the whole row.

The third solution, which does use text colour change to highlight rows where the checkbox has been checked does apply the conditional formatting directly to the cells to be formatted, comparing each to another cell whose content is determined by the state of the checkbox on that row. That solution was writen for a situation where the "the entire text on that line" was in a single cell. Here's an update to include tables where that text may be in more than one cell.

Shown at the right are the three column added to provide a cell for each of the custom highlighting rules to reference for comparison with the content of cells B2 to D10.

E2 contains this formula:

=IF($A,B,"")

If the cell in 'this row of' column A is TRUE (checked), copy the content of the cell in 'this row of' column B, if not, insert a null string.

The formula is filled down to the last row, and filled right to column G. Results can be seen in the cells of columns E, F and G.

Cells B2 - D10 were selected, and the Conditional Highlighting Rule shown below was entered. Unlike its predecessor, Numbers 3 allows choosing to Preserve row and or column of the cell reference or not choosing to do so. With the options left unchecked, each cell in the selection compares its value to that of the cell at the same relative location in E2-G10. (Probably the reason I chose to present only the 'all text in a single cell' version the first time.)

Columns E, F and G may be hidden.

Regards,

Barry

Hi toezo,

"I wrote =IF($A,B,""), Numbers show me an alert that the formula is not valid."

The most likely reason for your formula returning an error message is the use of commas ( , ) to separate the arguments in IF($A,B,""). If you are in a region that uses , as the decimal separator, then you must use a semi colon as the separator in formulas. eg. IF($A;B;"")

If that is not the issue, you'll need to show a screen shot of your table, with all of the columns involved in the formula visible, the cell containing the formula selected, and the Formula Editor (displaying the formula) dragged down a row or two to allow all parts of its row to be seen.

Regards,

Barry

One way to solve this is to make your current table filled with nothing (transparent), then place a new table with a single column that is as wide as the original table behind the original table.

In each cell of the single column place a formula that references the column with the check boxes:

In this example:

the table on the right (which should be sent to the back using the menu command "Arrange > Send To Back"):

A1=Original Table :: A1

select A1 and fill down. Then use the conditional formatting rules as shown

If the "text on that line" is in a single cell, you can set up a 'comparison cell', with it's content controlled by the checkbox, and used by a conditional formatting rule applied to the cell containing the text.

Here's an example:

The general rule is shown in the Conditional Format dialogue. The cell reference is to the adjacent cell in column B, and must be set for each cell to which the format is to be applied.

Cells in column B contain the formula

=IF(A,C,"")

Regards,

Barry

I can't achieve exactly what you want.

I may change the background according to the checkboxes.

In fact, I use two tables.

The first one is translucent.

In cell B2 of the second one the formula is :

=IFERROR(Tableau 1 :: B2,"")

Then, apply fill down

Define a rule applying to standard cells of the second table :

Then move the 2nd table behind the first one.

Yvan KOENIG (VALLAURIS, France) mercredi 29 février 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

I tried to follow your instructions I wasn't able to do exactly your steps.

Can you explain it easier?

I dont understand your formula and what I have to do with the rest.

I wrote =IF($A,B,""), Numbers show me an alert that the formula is not valid.

I am interesting in this issue. I would like to know how to do it

When conditional formatting with checkboxes, use the text is...true and then whatever you want it to do, such as turn green. For the cells that you don't want to check, dont give them a rule.

This works on the cell...haven't tried for a row