Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conditionally formatting a cell based on another cell

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditionally formatting a cell based on another cell

    Hello,

    I'm trying to figure out how to conditionally format a cell based on another cell..

    Example,
    Cell to be formatted in column AC
    Based on cell in column M

    If AC3 is blank or contains value "x"
    And M3 is not blank
    Then format AC3 with color

    Thank you for your help!

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    4,937
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditionally formatting a cell based on another cell

    Select column AC.
    Click Conditional Formatting > New Rule > Use a Formula > and enter:

    =AND(OR(AC1="",AC1="x"),M1<>"")

    Select your fill color.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  3. #3
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditionally formatting a cell based on another cell

    Try this:

    Select the cell or range of cells that you want Conditionally Formatted. In the case of your example, that would be AC3.

    Conditional Formatting > New Rule > Use a formula

    =AND(OR(AC3="",AC3="x"),M3<>"")

    Format however you'd like

  4. #4
    New Member
    Join Date
    Mar 2012
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditionally formatting a cell based on another cell

    Perfect!! Thank you so much! =)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com