+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting

  1. #1
    Registered User
    Join Date
    07-19-2005
    Posts
    8

    Conditional Formatting

    I am trying to apply a condional format to a range of cells in a column.
    I want the cells to turn green when a cell in an adjacent column = 5.
    Presumably this can be done by a formula in conditional formatting?
    Can anyone adsvise?

  2. #2
    KL
    Guest

    Re: Conditional Formatting

    Hi Andy,

    You are right. If you format the range [A2:A10] then:

    1) select the range [A2:A10] (make sure [A2] remains active)
    2) go to menu Format>Conditional Formatting
    3) In condition 1 choose 'Formula is' from the 1st dropdown
    4) put the following formula into the formula box: =B2=5
    5) presss the Format button and select your prefered formats
    6) press OK,OK
    7) try entering 5 into any cell in the range [B2:B10]

    Regards,
    KL


    "ANDYPAND" <ANDYPAND.1skiii_1122030394.9352@excelforum-nospam.com> wrote in
    message news:ANDYPAND.1skiii_1122030394.9352@excelforum-nospam.com...
    >
    > I am trying to apply a condional format to a range of cells in a
    > column.
    > I want the cells to turn green when a cell in an adjacent column = 5.
    > Presumably this can be done by a formula in conditional formatting?
    > Can anyone adsvise?
    >
    >
    > --
    > ANDYPAND
    > ------------------------------------------------------------------------
    > ANDYPAND's Profile:
    > http://www.excelforum.com/member.php...o&userid=25351
    > View this thread: http://www.excelforum.com/showthread...hreadid=389321
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1