Conditional Formatting

  • Thread starter Thread starter Grail
  • Start date Start date
G

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?
 
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
 
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.
 
Back
Top