Need a simple IF stmnt (I think).
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Need a simple IF stmnt (I think).

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

    Default

     
    Having a mental block this morning.

    From B5:B1000 I have values that result from
    a MAX function. If when all is said and
    done, and all my vaules in this range are
    > $0.00, I want to turn B1 Green. If not,
    then RED. A simple flag to tell me the
    Spreadsheet is completed. (Unless you have
    some other brilliant way to show this, like
    having fireworks go off or something ).

    Thanks for your help as always,
    Mike

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

    Default

    On 2002-03-14 05:04, Zac wrote:
    Having a mental block this morning.

    From B5:B1000 I have values that result from
    a MAX function. If when all is said and
    done, and all my vaules in this range are
    > $0.00, I want to turn B1 Green. If not,
    then RED. A simple flag to tell me the
    Spreadsheet is completed. (Unless you have
    some other brilliant way to show this, like
    having fireworks go off or something [img]/board/images/smiles/icon_smile.gif[/img] ).

    Thanks for your help as always,
    Mike
    Mike,

    How can you be Mike and Anonymous at the same time .

    Why not use conditional formatting?

    Activate B1.

    Activate Format|Conditional Formatting.

    Choose "Formula Is" for Condition 1.

    Enter in the formula box:

    =SUM(B5:B1000)>0.00

    Activate Format.
    Select green on the Patterns tab.
    Click OK.
    Activate Add.
    Choose 'Formula Is' for Condition 2.
    Enter as formula:

    =SUM(B5:B1000)<0.00

    Activate Format.
    Select red on the Patterns tab.
    Click OK, OK.

    Aladin


  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 your idea, but after reading your suggestion, I don't think it will work.
    Don't think we should be looking at the SUM > 0.00, or <$0.00..
    If any of the values are =$0.00 from B5:B1000,
    Then I need to expedite my suppliers and push them to complete their RFQ for us. The Green "flag" will tell me that I've posted all the costs required to complete the customer quote. Beats having to scroll down the column. Hope that helps.

    Have no idea how I can be Anonymous!!!
    I use ZAC as a nickname, and Mike's my given.


    I'll await your reaponse.
    ZAc

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

    Default

    On 2002-03-14 05:56, Zac wrote:
    Tried your idea, but after reading your suggestion, I don't think it will work.
    Don't think we should be looking at the SUM > 0.00, or <$0.00..
    If any of the values are =$0.00 from B5:B1000,
    Then I need to expedite my suppliers and push them to complete their RFQ for us. The Green "flag" will tell me that I've posted all the costs required to complete the customer quote. Beats having to scroll down the column. Hope that helps.

    Have no idea how I can be Anonymous!!!
    I use ZAC as a nickname, and Mike's my given.
    [img]/board/images/smiles/icon_smile.gif[/img]

    I'll await your reaponse.
    ZAc
    You're right.

    Make the first formula:

    =MIN(B5:B1000)>0.00

    and, the second:

    =MIN(B5:B1000)=0.00

    Aladin

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

    Default

      
    ALadin,

    Thanks for your help, that worked.
    Believe it or not I tried that formula initially, but I had a type-O and it failed.
    I'm awake now .

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