Results 1 to 10 of 10

conditional formatting a cell value

This is a discussion on conditional formatting a cell value within the Excel Questions forums, part of the Question Forums category; hi I have looked on Excel help for this but can't seem to find an answer. I am trying to ...

  1. #1
    Board Regular
    Join Date
    Mar 2004
    Location
    Lincs
    Posts
    104

    Default conditional formatting a cell value

    hi I have looked on Excel help for this but can't seem to find an answer. I am trying to conditonal format some cells. What I have is a symbol in say cell D9 and a number in D10. the symbol and number in both cells are generated by a formula.
    What I need to say in my conditional formatting is "if D9 is "x,y,z etc" then make red, green etc... However, because the symbol is generated by a formula, I can't just put D9="x,y". I was thinking of maybe a value formula but not sure how to use it?
    Hope this is clear?!

  2. #2
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,843

    Default Re: conditional formatting a cell value

    Hello,

    Perhaps some more information would be helpful.

    But,

    in D7 enter 1
    in D8 enter 0
    in D9 enter = D7+D8
    in D10 I have the formula =IF(D9=1,"x",IF(D9=2,"y","z"))

    on this cell I have conditional formatting

    Cell Value is equal to "x" and format as required.

    Do the same for Y and Z.

    Is this any help or have I missed the point completely?
    -------------------------
    Hope this is helpful.
    -------------------------

    Have been away from the forum for quite a while, but am now back.

  3. #3
    Board Regular
    Join Date
    Mar 2004
    Location
    Lincs
    Posts
    104

    Default Re: conditional formatting a cell value

    Thanks for this, but the cell that I want to conditional format already has the formula in, as does the one above it (D9 & D10), so I need the formula in the conditional formatting box. I'm finding it really difficult to explain!

    Lets try: D9 has a choose formula to put a symbol in if it meets certain criteria.
    D10 has another formula in relating to another work sheet to show numbers.

    I have conditional formatted the symbols in D9 to show red, green or black depending on what they are (simple cell value = "x" so green).
    I want to conditional format the numbers in D10 to be red, green or black depending on the symbol in D9, but because they are generated by a formula, I can't just put D9="x" so green.

    Does this make sense?!!

  4. #4
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    Format | Conditional Formatting

    {Cell Value Is} {Equal To} = "x,y"

  5. #5
    Board Regular
    Join Date
    Mar 2004
    Location
    Lincs
    Posts
    104

    Default Re: conditional formatting a cell value

    Hi, that still does not work because the cell value is not the cell i'm conditonal formatting? Thats the formula that I have in D9 - on the symbols. I'm formatting in D10 but the cell value I want to use is in D9?

  6. #6
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    In D10

    Format | Conditional Formatting

    {Formula Is} =$D$9="x,y"

  7. #7
    Board Regular
    Join Date
    Mar 2004
    Location
    Lincs
    Posts
    104

    Default Re: conditional formatting a cell value

    Thank you so much!!!!!!! O wise one

    I did not think that would work so I never tried that, as I though you just used $ to make the cell references stay put when dragging or pasting.

    Many thanks again.

  8. #8
    Board Regular
    Join Date
    Mar 2004
    Location
    Lincs
    Posts
    104

    Default Re: conditional formatting a cell value

    Sorry, I meant I never tried it before asking for help here, as obviously I have just tried it and it worked.....! Thanks

  9. #9
    Board Regular dnickelson's Avatar
    Join Date
    Oct 2003
    Posts
    118

    Default Re: conditional formatting a cell value

    In F10, enter
    {Formula is} =F9="x"
    for the conditional formatting

  10. #10
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default Re: conditional formatting a cell value

    Quote Originally Posted by chariot
    Thank you so much!!!!!!! O wise one

    I did not think that would work so I never tried that, as I though you just used $ to make the cell references stay put when dragging or pasting.

    Many thanks again.
    You're Welcome

    Take Care

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