Conditional Formatting Negative Numbers

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

In a report I want the calulated fild to show those
numbers less than 0 in bold red and those number greater
than 0 in green bold, I go into conditional formatting and
set it as such, however it does not seem to account for
the - infront of the number so all are showing up green.
Is there a way around this?
 
In a report I want the calulated fild to show those
numbers less than 0 in bold red and those number greater
than 0 in green bold, I go into conditional formatting and
set it as such, however it does not seem to account for
the - infront of the number so all are showing up green.
Is there a way around this?
Click to expand...


You do not need to use conditional formatting for this.
1) Set the control to Bold, as you want both positive and negative
numbers bold anyway.

2) Do you wish to show the minus sign for negative values as well as
change the color?
a) To not show the minus sign:
In the control's Format property, write:
#[Green];#[Red]
b) To show the minus sign:
#[Green];-#[Red]

You haven't said what you wish to do about 0 values!
To show 0 Values:
#[Green];-#[Red];0[Black]

See Access Help files:
Format + Number and currency datatype
 
Back
Top