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.