1 Reply Latest reply: Oct 16, 2010 9:11 AM by Jerrold Green1
4thSpace Level 1 Level 1
expertise.macosx
Mac OS X
How can the background color of a cell be changed conditionally, based on the resulting number from a formula in the same cell?

MacBook Pro Aluminum 2010, Mac OS X (10.6.4)
Solved by Jerrold Green1 on Oct 16, 2010 9:11 AM Solved
4thSpace wrote:
How can the background color of a cell be changed conditionally, based on the resulting number from a formula in the same cell?

4S,

You may not believe it, but the feature you need is called Conditional Format. See page 79 of the Numbers User Guide PDF for instructions. You will find the controls in the Cells Inspector.

Jerry
  • Jerrold Green1 Level 7 Level 7
    4thSpace wrote:
    How can the background color of a cell be changed conditionally, based on the resulting number from a formula in the same cell?

    4S,

    You may not believe it, but the feature you need is called Conditional Format. See page 79 of the Numbers User Guide PDF for instructions. You will find the controls in the Cells Inspector.

    Jerry