Parker

Select the entire row to color. Doesn't have to be row 2.

FormatConditional FormattingFormula is: =$J2="P"

Pick a color from from the Format button.

Note the $J2 must be entered as is with the $ sign.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 13:43:02 -0800, "Parker1333"
wrote:

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