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, :-)

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.
 
Right click on the object and you'll see a selection for conditional
formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top