Results 1 to 7 of 7

How to get 2 columns conditionally formatted against each other.

Threaded View

Nimmy How to get 2 columns... 08-05-2013, 09:00 AM
protonLeah Re: How to get 2 columns... 08-05-2013, 02:34 PM
Nimmy Re: How to get 2 columns... 08-06-2013, 02:31 AM
protonLeah Re: How to get 2 columns... 08-06-2013, 02:37 PM
Suraj3825 Re: How to get 2 columns... 08-06-2013, 02:56 PM
protonLeah Re: How to get 2 columns... 08-06-2013, 05:55 PM
Nimmy Re: How to get 2 columns... 08-08-2013, 05:03 AM
  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Norge
    MS-Off Ver
    Excel 2013
    Posts
    3

    Question How to get 2 columns conditionally formatted against each other.

    Hi, I hope some one can help, because I'm not sure you can do this.

    I wish to compare two columns with payments, one from the bank and one from accounting.
    Let me show you what I mean:


    I've been doing this manually, and it's starting to annoy me that I'm not smart enough to automate this.

    So, on one side -71515,84 is the same as the sum of the numbers on the right side. What I have to do is to check against the date, then do the sum and see if it's correct. I'd rather just mark it if it's correct and check the ones that are not.

    Can I do this with conditional formatting?

    Thank you!
    Attached Files Attached Files
    Last edited by Nimmy; 08-06-2013 at 02:31 AM. Reason: Fixed excel file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. counting conditionally formatted columns
    By greengem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 02:31 AM
  2. Sum of Items Conditionally Formatted
    By elfvis in forum Excel General
    Replies: 4
    Last Post: 12-13-2011, 09:32 PM
  3. Conditionally formatted date selection
    By CluelessNeedHelp in forum Excel General
    Replies: 6
    Last Post: 09-22-2010, 09:27 AM
  4. Sum conditionally formatted cells
    By akabraha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2010, 02:22 PM
  5. Reading a conditionally formatted cell
    By akronpow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2007, 03:57 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