Conditional Formatting on other Cell.

I would like to make a conditional formatting on one cell and it's depend on other cell result.

For example,

If CELL A1 show a number above 50. CELL A3, A4, A5 will fill with Yellow.

Can Apple Numbers 09 customise a conditonal formationg base on other CELL ?

Posted on Jan 5, 2014 1:41 AM

34 replies

Barry

Level 9

60,023 points

Jun 1, 2014 7:11 PM in response to addybails

test

Jun 2, 2014 1:27 AM in response to Jerrold Green1

Jerrold,

your solution works perfectly for me. It updates live without any user input.

Thanks again.

Jun 2, 2014 4:27 AM in response to addybails

Adam,

You're welcome. I do hope that you will consider starting your own thread for future questions. We hope to see you again.

Best,

Jerry

rebby575

Level 1

9 points

Nov 22, 2015 6:42 AM in response to iRaychan

Here is a really clear video that shows how to use formulas and reference other fields with conditional formatting in Numbers 3.

macmost.com/conditional-highlighting-in-numbers.html

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 Formatting on other Cell.