excel: How can I color code rows based on a value in a cell?
 

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

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.
.

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.