Conditional formatting in Numbers, part of Apple’s iWork suite, lets you format the contents of a cell based on certain rules.
So say you want to show all negative numbers as red and bold…conditional formatting lets us do that!
We’ll cover how to apply conditional formatting to numbers, text and dates in this TechUniversity screencast on Conditional Formatting with Numbers (subscription required).
Below is a sample of the video. The full screencast clocks in at just over 10 minutes.