Conditional formatting - Need quick Tip

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

fredg

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.
 

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

Top