Page 1 of 1

Conditional Format

Posted: Tue Sep 23, 2008 8:32 pm
by 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?

=> RE: Conditional Format

Posted: Wed Sep 24, 2008 8:54 pm
by 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

==> RE: Conditional Format

Posted: Thu Sep 25, 2008 9:08 am
by 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.