+ Reply to Thread
Results 1 to 5 of 5

Conditional format / text in another cell

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    HI
    Posts
    2

    Conditional format / text in another cell

    HI ALL,
    For now, I'm working with 2 cells. A1, and B1. I want cell B1 to turn blue in color if, A1=(RBS24 - L, or RBS16 - L, or H23 - L).


    Help / anyone???

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Conditional format / text in another cell

    Please Login or Register  to view this content.
    Where RBS24, L and RBS16 are names. H23 is Cell $H$23
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    10-28-2008
    Location
    HI
    Posts
    2
    Quote Originally Posted by rwgrietveld View Post
    [CODE]=H23 is Cell $H$23
    Are you saying that the program is thinking that I'm talking about a cell when I type H23?

    The formula was excepted with no errors, but it doesn't work.

  4. #4
    Registered User
    Join Date
    10-28-2008
    Location
    Dallas
    Posts
    7
    =IF(OR(A1="RBS24-L",A1="RBS16-L",A1="H23-L"),1,0)

    Added missing quotations; tested and working.

  5. #5
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    I assume you want conditional formatting of cell B1? If so, select B1, go to Format > Conditional Formatting, then from the drop-down box, select Formula Is, and type:

    =OR(A1="RBS24-L",A1="RBS16-L",A1="H23-L")

    Then click the format button and select blue pattern.

    HTH

    Jason

+ 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