+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 19

Formül

  1. #1
    Registered User
    Join Date
    06-16-2017
    Location
    Ankara
    MS-Off Ver
    win7
    Posts
    5

    Post Formül

    bir excel tablosunda G12 hücresinin değeri +750 den büyükse koyu mavi +500 den büyükse mavi +250 den büyükse yeşil ,-250 den küçükse H sütunun dolgu rengi sarı,-250 den büyük -500 den küçük olursa pembe,501 den büyük -750 den küçük olursa kırmızı olsun istiyorum ne yapmalıyım,nasıl bir formül yazmalıyım (ofis2003 kullanıyorum)
    Last edited by müezzin06; 07-05-2017 at 01:58 PM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    Re: Formül

    try here: Forum: Non English Excel (Ingilizce olmayan excel)
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    42,042

    Re: Formül

    I have moved this thread for you.

    Also, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    06-16-2017
    Location
    Ankara
    MS-Off Ver
    win7
    Posts
    5

    Re: Formül

    biraz daha açık yazarmısın,iplik nedir,kodları hangi menüden gireceğim

  5. #5
    Registered User
    Join Date
    06-16-2017
    Location
    Ankara
    MS-Off Ver
    win7
    Posts
    5

    Re: Formül

    Bir excel tablosunda G12 hücresinin değeri +750 den büyükse koyu mavi +500 den büyükse mavi +250 den büyükse yeşil ,-250 den küçükse H sütunun dolgu rengi sarı,-250 den büyük -500 den küçük olursa pembe,501 den büyük -750 den küçük olursa kırmızı olsun istiyorum ne yapmalıyım,nasıl bir formül yazmalıyım (ofis2003 kullanıyorum) örnek bir dosyayı:http://www.dosyaupload.com/account_home.html deneme adlı dosyayla yükledim kulanıcı adı:uzman59 dosya adı:deneme

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    16,012

    Re: Formül

    You will receive no help until you have changed your thread title. This change was requested in post #3. Thank you for your co-operation.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  7. #7
    Registered User
    Join Date
    06-16-2017
    Location
    Ankara
    MS-Off Ver
    win7
    Posts
    5

    Formül

    bir excel tablosunda G12 hücresinin değeri +750 den büyükse koyu mavi +500 den büyükse mavi +250 den büyükse yeşil ,-250 den küçükse H sütunun dolgu
    ofiss2003 kullanıyorum

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    Re: Formül

    GTranslation

    From post #6
    İplik başlığınızı değiştirene kadar hiçbir yardım almayacaksınız. Bu değişiklik, posta # 3'te istendi. İşbirliğiniz için teşekkürler.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    42,042

    Re: Formül

    müezzin06 to get other members to help you, you MUST change your title, as I have requested

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    16,012

    Re: Formül

    The OP is sending private messages to try to get help. I do not understand why he will not change his thread title.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    42,042

    Re: Formül

    Dont understand the language, so I cant even change it for them

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    42,042

    Re: Formül

    Quote Originally Posted by sandy666 View Post
    GTranslation

    From post #6
    İplik başlığınızı değiştirene kadar hiçbir yardım almayacaksınız. Bu değişiklik, posta # 3'te istendi. İşbirliğiniz için teşekkürler.
    You seem to understand what is being said, can you suggest a title change to me please?

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    16,012

    Re: Formül

    Google Translate's attempt at the Turkish original:
    In an excel table, the value of G12 cell is +750 denier, dark blue +500 denier blue, +250 denier green, -250 denier, H column fill color is yellow, -250 denier is -500 denier if pink, 501 denier is -750 denier I want to red if it is small what should I do, what formula should I write (I use office2003)
    This would appear to be about conditional formatting.

  14. #14
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    838

    Re: Formül

    I think they want the below series of conditional formats

    over 750 dark blue
    750 to 500 blue
    500 to 250 green
    -250 to 250 yellow
    -250 to -500 pink
    -501 to -750 red
    ...
    and maybe below -750 would be deep red?

  15. #15
    Registered User
    Join Date
    06-16-2017
    Location
    Ankara
    MS-Off Ver
    win7
    Posts
    5

    Re: Formül

    nasıl değiştirebilirim yardım lütfen

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1