Hello,
I created the following report and need to apply conditional formatting depending on the value:
SUM
X
Y
BY Z
ACROSS YEAR

---------2011---2012---2013
Z--------X-Y----X-Y----X-Y
data1----p-g----p-g----p-g
data2----r-u----r-u----r-u
....


When i try to apply the formatting below output=HTML, i get the expected result, if i try output=AHTML this does not work. Any thoughts on how to make this work for ATHML?

TYPE=DATA, ACROSSCOLUMN=N1,
BACKCOLOR=RED, WHEN=X EQ 'P', $
TYPE=DATA, ACROSSCOLUMN=N1,
BACKCOLOR=YELLOW, WHEN=X EQ 'R', $


TYPE=DATA, ACROSSCOLUMN=N2,
BACKCOLOR=GREEN, WHEN=Y EQ 'G', $

TYPE=DATA, ACROSSCOLUMN=N2,
BACKCOLOR=LIME GREEN, WHEN=Y EQ 'U', $

This message has been edited. Last edited by: Daryl H.,

Try with WHEN=N3 EQ ... instead of 'Y'.
In my experience using column names in ACROSS style-rules is unreliable at best.

This doesn't help you at all, but it may help someone to come up with a solution: provide an example using one of the sample tables - in this way, we can tweak the code until it works. I can't see a reason why the styling doesn't work for AHTML - it works for HTML, PDF, Excel 2000 and PowerPoint.

TABLE FILE GGSALES
SUM
DOLLARS
UNITS
BY REGION
BY ST
ACROSS PRODUCT

ON TABLE PCHOLD FORMAT HTML

ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=DOLLARS,
BACKCOLOR=RED, WHEN=DOLLARS LT 300000, $

TYPE=DATA, ACROSSCOLUMN=DOLLARS,
BACKCOLOR=YELLOW, WHEN=DOLLARS GT 300000, $

TYPE=DATA, ACROSSCOLUMN=UNITS,
BACKCOLOR=GREEN, WHEN=UNITS LT 30000, $

TYPE=DATA, ACROSSCOLUMN=UNITS,
BACKCOLOR=LIME GREEN, WHEN=UNITS GT 30000, $

END

Thank you all for the responses.