+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting based on 3 conditions

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    Sayreville, NJ
    MS-Off Ver
    Excel 2003
    Posts
    2

    Wink Conditional Formatting based on 3 conditions

    Hello. I use Excel 2003. I know its out dated but its the version i have to use at work. I need to highlight a cell based on conditions of 3 other cells on the same row...

    Condition 1
    Cell B2 must not be blank

    Condition 2
    Cell K2 must be blank

    Condition 3
    Cell H2 must not contain the string "NRN"

    Then, if all conditions pass, D2 should be highlighted in RED

    I appreciate any help I can get on this.

    Thanks
    nycDave
    Last edited by nycdave; 05-23-2011 at 01:51 PM. Reason: Solved.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Conditional Formatting based on 3 conditions

    Hi and welcome to the board


    Perhaps

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,843

    Re: Conditional Formatting based on 3 conditions

    Select your range (i.e D2) and conditional format > Use Formula

    =AND(ISBLANK($B2),ISBLANK($K2), ISNUMBER(FIND("NRN",$H2)))
    Format as red
    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    05-23-2011
    Location
    Sayreville, NJ
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional Formatting based on 3 conditions

    Thanks guys and/or gals. You guys nudged me in the right direction. Arthur, yours didn't work and ChemistB didn't work the right way. I saw Arthur's use of the NOT parameter and applied them to ChemistB's input and it work. Thanks for the help. This is solved!!

    NYCDave

+ 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