1. Select row 2.
2. Go to Format Conditional Formatting. Select "Formula
Is"
3. Insert: =$J$2="P"
4. Click the "Format" button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
Jexample: If the value in cell J2=P, then shade the
entire row in yellow.
.