Conditional formatting - Need quick Tip

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I set up a report to where is the value in the text field is greater than X
color it red else green. I did this so long ago I forgot how and where I set
it up. Can you let me know where I go to do this. Thanks, :-)
 
I set up a report to where is the value in the text field is greater than X
color it red else green. I did this so long ago I forgot how and where I set
it up. Can you let me know where I go to do this. Thanks, :-)
Click to expand...

In Report Design View, select the control on the report.
Set it's color to Green.
Then click on Format + Conditional Formatting
Set Condition1 to
Field Value Is
Then select in the next box:
Greater Than
Write
X (the value)
in the next box.
Select the Red color and click OK to save the change.

That should be all you need do.
 
Back
Top