Angela: In the case of Excel 2003, what appears in the PivotTable is
(blank), and it appears to be treated as text. The conditional IF
((a1="(blank)", T, F) appears to work well.

Now the color....that I don't know how to do.

Chuck