This/Me Keyword 1

[madcrystal]

I'm trying to change the font color based on the value. There are about 40 places on the page I have to do this, and I'd prefer not to specify the report field each time. Instead, I'm trying to create something Copy/Paste-able like this:

if {Me} >= 0 Then crGreen
Else crRed

Logically, you're accessing the format editor through the report field it's affecting - there must be a way to not have to re-specify? Maybe I'm missing an even better way to accomplish this?

Thanks!

 

[lbass]

You could select all relevant fields at once and then apply this formula:

if currentfieldvalue >= 0 then
crGreen else
crRed

-LB