Highlighting Calculated fields

  • Thread starter Thread starter John Ortt
  • Start date Start date
J

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
 
John Ortt said:
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)
Click to expand...

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"
 
Back
Top