field color dependant on value in Report 1

[irethedo]

I have a report that I wish to have display live data and in one field on this report I would like the color of the text in that field to be displayed in RED if the number in that field is less than another number in my table or displayed in GREEN if it is equal to or greater than the number in the table

How can I set this up?

Thanks

 

[Remou]

Have you looked at Conditional Formatting?

 

[irethedo]

Thank you Remou-

Knowing where to look is the key to finding some of these options!

Your tip helped

 

[irethedo]

I was able to get this working but I have a couple of other fields that I want to change the text color based upon values of other fields but it is not working...

I have the following equation set up in 3 different "expression is" fields of the conditional format form for control [total]:

"[Day_Target]>[Day-Current]"
"[Day_Target]<[Day-Current]"
"[Day_Target]=[Day-Current]"

If any of the above statements are true, shouldn't this control [total] be displayed in the color secified for the condition?

Do I have the format for the "Expression is" field correct?

 

[Remou]

Did you include the quotations? If so, that could be the problem. Unquoted is the right way:
[tt][Day_Target]>[Day-Current][/tt]

 

[irethedo]

thanks- that was the ticket!