On May 24, 9:12 pm, brian <b...@discussions.microsoft.com> wrote:
> That worked. I ad the syntax wrong. Thanks!
>
> "EMartinez" wrote:
> > On May 24, 2:46 pm, brian <b...@discussions.microsoft.com> wrote:
> > > In RS, is it possible to code an expression so that if a field contains the
> > > word "STAT" that whole row is highlighted in another color? If not, how about
> > > a that field?
>
> > > I can do it with numeric values, not text.
>
> > > Thanks.
>
> > In Layout view, select the field that you want to change the
> > background color for and select F4 (for the Properties window). To the
> > right of Background Color, select <Expression...> and enter an
> > expression similar to the following:
> > =iif(Fields!FieldName.Value Like "*STAT*", "Orange", "White")
> > Hope this helps.
>
> > Regards,
>
> > Enrique Martinez
> > Sr. Software Consultant