Use Conditional Style to set rules for how columns and rules and should look under certain circumstances. You can select one of the the predefined styles (e.g. green font for positive numbers) or you can create your own.
The Conditional Styles uses the same Expression engine as Advanced Search and Plus Minus so you can make the rules for when a style should appear as simple or complex as you want and as best fits your data.
You can choose between applying a style for a single column or for a whole row.
You can create as many styles as you require; if two styles clash, column styles take precedence over row styles.
+44 (0)20 7078 4141