Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Conditional formatting based on a different cell

This is a discussion on Conditional formatting based on a different cell within the Excel Questions forums, part of the Question Forums category; I would like to apply conditional formatting to several cells depending upon the value of a single (different) cell... Is ...

  1. #1
    New Member
    Join Date
    Mar 2004
    Posts
    13

    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
    64,708

    Default Re: Conditional formatting based on a different cell

    Yes.

  3. #3
    New Member
    Join Date
    Mar 2004
    Posts
    13

    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
    64,708

    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

    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
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    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
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    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

    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
    64,708

    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
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    Your welcome.

    Take Care

Page 1 of 2 12 LastLast

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