Hi Tiffany,
What do you mean with selecting pages, are different Pivot Tables, or
different design


"Tiffany" wrote:

i did but when i change my selection in page view, the format disappear. how?
Actually i want number less than 0 to be in red. So regardless of what page i
select, it will always show the negative figures in red.

thank you.

"Eduardo" wrote:

Hi Tiffany,
Highlight the cells you want to apply Conditional Formating, go to
conditional formating,new rule, use 2nd option "Format only cell that
contain", in Edit rule choose cell value less than and enter 0 then go to
format, Font, color, choose your color, click OK

if this helps please click yes, thank you


"Tiffany" wrote:

sorry... forgot to mention. I am using office 2007. thanks!

"Jacob Skaria" wrote:

http://www.contextures.com/xlCondFormat01.html

If you are using 2003 or previous conditional formatting do not move
with the cells....

If this post helps click Yes
---------------
Jacob Skaria


"Tiffany" wrote:

Hi,

I have a pivot table and i want to set conditional format in the pivot
table. e.g. for any cell value less than 0, i want to the font color to
appear in red. May i know how to do it.

Thank you.