Jexample: If the value in cell J2=P, then shade the entire row in yellow.
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.
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
On Tue, 1 Feb 2005 13:43:02 -0800, "Parker1333"
<[email protected]> wrote:
>Jexample: If the value in cell J2=P, then shade the entire row in yellow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks