I'm trying to highlight cells greater than .50 for an across data element (ie. the field appears in several columns). The number columns vary with each query, so I don't want to specify every other column, but when I use the fieldname, the traffic lighting only works on the first column that displays the field, not all the rest.

Any ideas would be appreciated. Thanks!

TYPE=DATA,
COLUMN=MKTPCT,
BACKCOLOR=RGB(255 255 0), WHEN=MKTPCT GT .5,$

Use the Syntax like below. This does the work.

quote:

Originally posted by DougTrev:
[qb]
TYPE=DATA,
ACROSSCOLUMN=MKTPCT,
BACKCOLOR=RGB(255 255 0), WHEN=MKTPCT GT .5,$ [/qb]