1 Reply Latest reply: Oct 16, 2010 9:11 AM by Jerrold Green1
4thSpace Level 1 Level 1 (0 points)
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)
  • 1. Re: Conditionally change cell color in Numbers '09
    Jerrold Green1 Level 7 Level 7 (28,995 points)
    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