Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2003
    Location
    Camp Springs, Kentucky, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format row based on single cell contents (Excel 2002/SP2)

    Does anyone know of a way to format an entire row based on the contents of one cell?

    For example, if A1 contains "yes", make the background color of all cells in row 1 yellow.

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format row based on single cell contents (Excel 2002/SP2)

    Try the following:

    1- Select the row to be formatted.

    2- Select "Conditional Formatting ..." from the Format menu.

    3- In the drop down list on the left select "Formula is".

    4- Enter this formula in the formula text box:

    <pre>=UPPER($A$1)="YES"
    </pre>


    5- Click on the Format button.

    6- Click on the Paterns tab.

    7- Click on the color you want for the background color.

    8- Click on OK to close all dialor boxes.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •