Jexample: If the value in cell J2=P, then shade the entire row in yellow.
P Parker1333 Feb 1, 2005 #1 Jexample: If the value in cell J2=P, then shade the entire row in yellow.
J Jason Morin Feb 1, 2005 #2 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
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
G Gord Dibben Feb 1, 2005 #3 Parker Select the entire row to color. Doesn't have to be row 2. Format>Conditional Formatting>Formula 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
Parker Select the entire row to color. Doesn't have to be row 2. Format>Conditional Formatting>Formula 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
