Conditional Format

[Jill_(Guest)]

I am wondering if you can do a conditional format on fields. I have an if statement set up, but I want to be able to change the formatting of the field if it returns a certain value. Is this possible?

[kfleming]

What you need to do is to create two separate fields mutually exclusive fields. Then you format each individually and place one on top of the other on the layout.__For example:__IIF(SALES>=100,^MEETS GOAL^,^^)__format in font color black____IIF(SALES<100,^BELOW GOAL^,^^)__format in font color red____Then depending on the value of the SALES field, you will get either a black MEETS GOAL or a red BELOW GOAL on the layout.____Kathleen__R&R Support

[Robert_Seidman]

I use this trick all the time, and it works just fine, but it would be a real enhancement if R&R would offer a field option that would allow you to conditionally format a field without having to go through all this.