12070 Views 1 Reply Latest reply: Oct 16, 2010 9:11 AM by Jerrold Green1
How can the background color of a cell be changed conditionally, based on the resulting number from a formula in the same cell?
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.