I am using a pivot table to track data. (1) I want to color code fields to
track the occurrences of my data. Used Conditional Formating, but does not
remain on fields when needing to change color code for other occurence of
different data. (2) Is there a way to format for "containing" text in Excel
2003? I have a variety text that means the same thing and realize there is
only an ability to search 3 times. I realize 2007 has the "contain"
capability, as well as being to search more than 3 times for text and am
jealous of that fact.

Please make your solution as simple that a baby could follow, I'm new to
Excel and don't know a great deal.

Ex.

TABLE Column 1

ABC Agency Location (color green)
AB1 Agency Loc (color green)
DEF Insured
DE1 Insured Property (color yellow)
XYZ AL (color green)
XY1 Ins Propety (color yellow)