+ Reply to Thread
Results 1 to 2 of 2

AP / AR Trigger for negitive numbers

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    4

    AP / AR Trigger for negitive numbers

    Hey Gang, so I come to the experts for some advice, again.

    I have a spread sheet with many cells (A:ZZ & 10 to 40009)

    In column F, I have a drop down list giving 2 choices, AP & AR. These are the main triggers for what I need to happen.

    When I select "AP" in column F, I need column I to see only a negative number (-$100), and at the same time in column M, I need it to see only a positive number ($100)

    When I select "AR" in Column F, I need column I to see only positive number ($100), and at the same time in column N, yes N, I need it to see only a negative number (-$100)

    there are other conditions to the cells I need, but those I have figured, its this one that is stumping me.

    I have included a bit of an example with this question
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: AP / AR Trigger for negitive numbers

    Hi and welcome to the forum

    You *could* do this with Conditional Formatting, formatting text color to while if the condition is met. But I think that with that many rows/columns the CF will slow your file down

    Another option would be to add helper columns that contain formulas like =if(F4="AP",I4,"") etc. You could then hide the F and M columns
    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 someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to only add negitive numbers in selected field
    By Alexander.Tartter in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-05-2013, 12:36 PM
  2. Count only if negitive and only if positive.
    By gibbsmachine in forum Excel General
    Replies: 3
    Last Post: 12-21-2011, 09:27 AM
  3. How do I change numbers from positive to negitive
    By Debi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2005, 01:09 PM
  4. Making a cell Negitive only
    By hw in forum Excel General
    Replies: 5
    Last Post: 05-24-2005, 06:32 AM
  5. [SOLVED] negitive and positive numbers
    By kematz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2005, 07:06 PM

Tags for this Thread

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