User profile for user: DJ996
DJ996 Author
User level: Level 1
10 points

Conditional rule related to value of a tick box

New to Numbers. I've sort of got my head round the fact that to change colour of a cell requires Conditional Rules rather than a formula.

I have a cell (let's say R4). Next to it is a Tick box (say R5)

All I want to do is change the colour in R4 when R5 is ticked.

But if I select R4 and attempt to set a rule, there seems to be no way to relate that rule to the tick in, or value of, R5, and vice versa. I can see the Text rule gives options to select dependent cells, but that doesn't help.

Any thoughts anyone?

Thanks.


Posted on Jan 7, 2025 11:47 AM

Reply
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
30,456 points

Posted on Jan 7, 2025 5:38 PM

Here is a similar way to do it that will allow you to conditional highlight more than one cell in the row, or the entire row.




Formula in D2 =IF(C2,"~","")

fill down


Select the cells that need the highlighting rule (B2:C8 in my example). Make the rule as if you were doing only the top left cell of the range (cell B2). Choose cell D2. Lock in the column with a $ so it becomes $D2. Click the green checkmark.


If the data in any of your cells might end in "~", you can use a less common character. I often use CHAR(10000) which is a little pencil image.

D2 =IF(C2,CHAR(10000),"")

View in context
2 replies
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
30,456 points

Jan 7, 2025 5:38 PM in response to DJ996

Here is a similar way to do it that will allow you to conditional highlight more than one cell in the row, or the entire row.




Formula in D2 =IF(C2,"~","")

fill down


Select the cells that need the highlighting rule (B2:C8 in my example). Make the rule as if you were doing only the top left cell of the range (cell B2). Choose cell D2. Lock in the column with a $ so it becomes $D2. Click the green checkmark.


If the data in any of your cells might end in "~", you can use a less common character. I often use CHAR(10000) which is a little pencil image.

D2 =IF(C2,CHAR(10000),"")

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Conditional rule related to value of a tick box

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up