Pivot Table Questions
 

I have 3 questions I have been update to solve....

1) When i use conditional formatting in a pivot table (Excel 2007), I
cannot get it to retain the formating when filtered or modified. Based on
what I've read - -this should work now in the new version. I have unchecked
the box in Pivot Table options for auto fit the width, and check the preserve
formatting.

2) I want to create a conditional format that if the results of 1 column (%
of project completion) are 50% and the column I'm formatting is < a
specific value -- that the field is shaded a color. Can I do that?

3) Can I create a caluclated field that if 1 column is value *x" and anothe
column is value "y" - -that the new calcualted fields gives me a text value
results "overburn"???