Possible to change the background color of a row in Numbers automatically if a checkbox in that row is checked or in some other automatic way?

Here is another way that does not require a separate table, just one extra column in the existing table

Formula in cell F2 is =IF(E,CHAR(10000),"")

fill down to complete the column

Select all of columns A-E except the header row (and any footer rows)

Make a conditional format that looks like the one in the screenshot.

The box that has $F2 in it will start out empty with a green oval. Click on the green oval then click cell F2. Change it so it is $F2. Click the green checkmark to accept it. Then choose the formatting options (I didn't mean to make mine italics).

Hide column F when it is all set up and working. The formula and custom highlighting should auto-populate any new rows added later.

BTW, if you are using Unicode character 10,000 (2710 hex) for anything else in your table, use another character in the formula. It is a little pencil. I use this character because it is unlikely to be found in a spreadsheet.

Hi dbooster,

here is one way. Insert another table (1-1). You can hide this table on another sheet when all is working.

Formula in table 1-1 A2: IF(Table 1::$D2,Table 1::A2,"^*")

Fill right and down.

The nonsense text ^* can be any text that can not possibly occur in Table 1.

Select all body cells in Table 1 and apply a Conditional Highlighting rule:

Tip: to include a cell reference in the rule,

Numbers will adjust the cell reference to other selected cells of table 1.

Regards,

Ian.