Conditional formatting based on a different cell

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Conditional formatting based on a different cell

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

    Default Conditional formatting based on a different cell

     
    I would like to apply conditional formatting to several cells depending upon the value of a single (different) cell... Is this possible without code?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,443
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    Yes.

  3. #3
    New Member
    Join Date
    Mar 2004
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    Can you elaborate?

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,443
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    Quote Originally Posted by Max Girth
    Can you elaborate?
    Why me? It's, as far as I know, not me who wants to cond format several secret cells depending upon again a secret cell while no condition specified.

  5. #5
    New Member
    Join Date
    Mar 2004
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    hmmm...

    OK...
    Make the font in A1 change to red if J1=>0
    Without putting a formula in a1...
    There's already one there.[/quote]

  6. #6
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In conditional formatting select "Formula Is" then put in the formula you want.

    So in cell D7 if you wanted it to be conditionally formatted if A1 = 5 then put

    "Formula Is" =if(A1=5,True,False)

  7. #7
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select A1 | Format | Conditional Format

    select "Formula Is"

    =If(J1>=,True,False)

    Then set what formatting you want.

  8. #8
    New Member
    Join Date
    Mar 2004
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    Thank you DRJ

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,443
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting based on a different cell

    Quote Originally Posted by Max Girth
    hmmm...

    OK...
    Make the font in A1 change to red if J1=>0
    Without putting a formula in a1...
    There's already one there.
    That's better.

    Activate A1.
    Activate Format|Conditional Formatting.
    Choose Formula Is for Condition 1.
    Enter the following in the white box:

    =(A1<>"")*($J$1>0)

    Activate the Format button.
    Select red as Color from the Font tab.
    Click OK, OK.

  10. #10
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Your welcome.

    Take Care

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