Results 1 to 7 of 7

Thread: [RESOLVED] Sum of 2 rows (Used Range), check negative (VBA)

Threaded View

  1. #1

    Thread Starter
    PowerPoster Radjesh Klauke's Avatar
    Join Date
    Dec 2005
    Location
    Sexbierum (Netherlands)
    Posts
    2,244

    Resolved [RESOLVED] Sum of 2 rows (Used Range), check negative (VBA)

    Not sure how to describe this but I'll give it a go:

    If have 3 Columns: A, B C

    Example:

    * A B C
    1 5 4
    2 7 1
    3 3 7
    4 2 1

    Now I want to do a sum of Col.A MINUS Col.B >> Answer in Col.C >> If Col.C is negative, then color.
    When using my example, Row 3 should be colored.

    I hope someone understands what I'm trying to do.

    Thanks in advance.
    Last edited by Radjesh Klauke; Dec 25th, 2012 at 07:17 PM.


    If you found my post helpful, please rate it.

    Codebank Submission: FireFox Browser (Gecko) in VB.NET, Load files, (sub)folders treeview with Windows icons

Posting Permissions

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



Click Here to Expand Forum to Full Width