Conditional Formating Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a row of text boxes in my report that are calculations in a footer.
I've tried to setup conditional formating so that if the results of the
calculation are less than zero the font shows red.

I get several of them working but once I get past 4 or 5 of them I lose the
results and get #Name? in some and #Error in others...even the ones that were
working before putting in the next condition.

Any suggestions? (Also, when setting up the conditions, at the top of the
conditions box where it has the Default formating that will be used if the
condition is not met, the background color is set and won't allow me to
change it.
 
If you only want to show negative numbers in red, you don't need conditional
formatting. Search Help on "Numeric Format" and find an example Format
Property setting like:
$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
This format property will display negative numbers in red and positive in
green.
 
Thank you so much....perfect!

Duane Hookom said:
If you only want to show negative numbers in red, you don't need conditional
formatting. Search Help on "Numeric Format" and find an example Format
Property setting like:
$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
This format property will display negative numbers in red and positive in
green.
--
Duane Hookom
MS Access MVP
--

neenmarie said:
I have a row of text boxes in my report that are calculations in a footer.
I've tried to setup conditional formating so that if the results of the
calculation are less than zero the font shows red.

I get several of them working but once I get past 4 or 5 of them I lose
the
results and get #Name? in some and #Error in others...even the ones that
were
working before putting in the next condition.

Any suggestions? (Also, when setting up the conditions, at the top of the
conditions box where it has the Default formating that will be used if the
condition is not met, the background color is set and won't allow me to
change it.
Click to expand...
Click to expand...
 
Back
Top