Highlighting Calculated fields

[John Ortt]

Another quick question.

If a calculated result in a field is less than 0 I want the cell to have a
red background.....

Is there a way do do this?

(similar to conditionnal formatting in Excel)

Thanks again everyone,

John O

 

[Rick Brandt]

Another quick question.

If a calculated result in a field is less than 0 I want the cell to have a
red background.....

Is there a way do do this?

(similar to conditionnal formatting in Excel)

The format property for numbers can have four sections separated by semi-colons.
These will apply formatting respectively to...

The format for positive numbers.
The format for negative numbers.
The format for zero values.
The format for Null values.

This example displays zero values in Red.

$#,##0.00;($#,##0.00);$#.##0.00 [RED];"Null"