Conditionally formatting a cell based on another cell

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
    5,517
    Post Thanks / Like
    Mentioned
    16 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,569
    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
  •  

 

 
DMCA.com