Look in the formatting menu at conditional formatting.

Use the macro recorder while doing it manually to get the syntax for
applying the conditional formatting using code.

Regards,
Tom Ogilvy

ALF wrote in message
...
Hi All,
I'm extracting data from an OLAP cube into a pivot table
in Excel. I'm then asving as a web page for others to
view. All is good so far. My problem arises where I have
a requirement for the figures in the totals column to be
color coded depending on their value. ie. if total < 50
then red, 50 then green etc. I'm new to excel so any
help , pointers are much appreciated.

Thanks,
ALF

Thanks for the swift response Tom.
I can conditionally format the pivot table in excel,
however, when I publish the table, (save as a web page),
it loses all formatting. Is there any way of retaining
this?

Thanks again,
ALF

-----Original Message-----
Look in the formatting menu at conditional formatting.

Use the macro recorder while doing it manually to get
the syntax for
applying the conditional formatting using code.

Regards,
Tom Ogilvy

ALF wrote in message
...
Hi All,
I'm extracting data from an OLAP cube into a pivot
table
in Excel. I'm then asving as a web page for others to
view. All is good so far. My problem arises where I
have
a requirement for the figures in the totals column to
be
color coded depending on their value. ie. if total < 50
then red, 50 then green etc. I'm new to excel so any
help , pointers are much appreciated.

Thanks,
ALF


.

If you convert it to static HTML and it is no longer a Pivot Table, then no,
you would have to color the cells of the table.

Regards,
Tom Ogilvy


ALF wrote in message
...
Thanks for the swift response Tom.
I can conditionally format the pivot table in excel,
however, when I publish the table, (save as a web page),
it loses all formatting. Is there any way of retaining
this?

Thanks again,
ALF

-----Original Message-----
Look in the formatting menu at conditional formatting.

Use the macro recorder while doing it manually to get
the syntax for
applying the conditional formatting using code.

Regards,
Tom Ogilvy

ALF wrote in message
...
Hi All,
I'm extracting data from an OLAP cube into a pivot
table
in Excel. I'm then asving as a web page for others to
view. All is good so far. My problem arises where I
have
a requirement for the figures in the totals column to
be
color coded depending on their value. ie. if total < 50
then red, 50 then green etc. I'm new to excel so any
help , pointers are much appreciated.

Thanks,
ALF


.