Conditional Formatting

[Grail]

In my data base I am asking to color code field "A" in green if the amount
is less than filed "B". I have also asked for field "A" to highlight blank
records in purple. Can you ask for different colors and different criteria of
the same field? I tried doing this and it worked for only the purple
expression and highlighted in green the oppposite field of my expression? I
hope this make sense?

 

[Linq Adams via AccessMonster.com]

Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given
control.

If the form is a Single View Form you can have as many conditions as desired,
using code in the appropriate control's AfterUpdate event as well as in the
Form_Current event.

What exactly is your situation?

 

[Grail]

I am working in reports. I do not know how to ask for the difference between
two columns of numbers. I want to show when one column of numberes is larger
that the other by color coding it. When I ask this I get the opposite result.
see example:
Per occurance amount

 

[Grail]

here is my situation:
In my report I am asking to color code a field in the "Per Occurance Amount"
column when the dollar amount is less than the "Contract Per Occurance
Amount" column. When I ask this in my conditional formatting box it colors a
box in the "Per Occurance Amount" column when it is greater than the
"Contract Per Occurance Amount" column. In other words I get the opposite
result of my question.

 

[Grail]