Changing colors for specific values

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

Anthony Viscomi

I have a Report that contains gasoline volume data; the data derives from a
query that contains 2005 & 2004 data for each site, compare the data and
calculates the % of volume the station is at compared to prior year.

My report contains all sites (400+) along with all of the above data. My
question is how can I change the color of the text display on the report if
a site isn't meeting certain criteria?
Example: Site #1 % vs. prior year <50% then text = RED

Thanks in advance!
Anthony
 
Hi,
check out conditional formatting.
Under the format menu option you will find it. Select the control you want
to format and go there, then type in your expression.
HTH
Good luck
 
Back
Top