Changing the color of a cell based on a formula.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Changing the color of a cell based on a formula.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    In O15 I will have either of the following:
    =Max(R15:AM15)
    =Min(R15:AM15)

    I have a button with a Macro attached that
    let's us change from Max to MIN.

    In Cell O8 I would like to have "MIN"
    In Cell O9 I would like to have "MAX"
    Is there a way to highlite either O8 or O9
    with a colored background or Text alerting the user which formula is activated?

    Maybe by using the Left (Fx) to view the 4
    LEFT characters of O15 or something like that.

    Any other ideas would be acceptable also.

    As always Thanks for U R help,
    Mike

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could this work????? Just changing O8 to a conditional formula that changes to "MIN" or MAX", based on the value of O15???

    =IF(O15=MIN(R15:AM15),"MIN","MAX")

    If not, yell and I'll play some more

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tried the following :

    =IF(O15=Min(R15:AM15),"Min","Max")

    It worked when the formula was Min, but
    it didn't change to Max when the formula wasn't Min(.......). In this case it was Max(.....).

    Any other suggestions.

    Zac

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If the formula in cell O15 changes from Min to Max when you click your Macro button, then this should work and cell O8 will change from "Min" to "Max" as well....if not, there is a typo, or i don't quite understand what is in cell O15.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    O15 has a resulting Numerical value based
    on what is pulled in by the Min and Max formula.

    =IF(O15=MIN(R15:AM15),"MIN","MAX")

    Again when I hit the button to change the reqmnt from Min to MAX.
    Min shows up in O8. Always.

    I'm baffled.. I know it should work too, but it doesn't.

    HELP.

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