Results 1 to 3 of 3

Assistance: Conditional formatting comparison between two FILES.

Threaded View

omni13 Assistance: Conditional... 10-29-2013, 06:08 AM
ganeshkumar Re: Assistance: Conditional... 10-29-2013, 06:12 AM
omni13 Re: Assistance: Conditional... 10-29-2013, 06:52 AM
  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    14

    Assistance: Conditional formatting comparison between two FILES.

    Scenario:
    I have a new task that I may need some help wrapping my head around. I decided to ask here while I also attempted to come up with a solution. I have two different excel files. A budget, and an expense file. Each has many processes to determine numbers. I think the best method would be to duplicate them and simply add the Expense processes to one of them.

    Budget file/sheet has estimated costs.
    Expenses are actual costs.

    My question:


    How would I go about setting up conditional formatting on 2 years+ worth of months to compare budget expense values between the two files. Also is this possible? To read from a closed file or pull information from it to compare? I would want differences to be red for greater than value, yellow equal, and green as less than. As well I don't formating to be broken if new columns are added. Would I have to manually add range names to the cells?

    Any assistance would be greatly appreciated!

    Edit: I added one of the sheets I look to duplicate. or insert into another file where expenses are housed. I threw in some arbitrary numbers to sample.
    Attached Files Attached Files
    Last edited by omni13; 10-29-2013 at 06:59 AM. Reason: Added sheets.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. assistance with conditional formatting
    By PeterG in forum Excel General
    Replies: 3
    Last Post: 10-29-2015, 05:39 PM
  2. Conditional formatting (i think) assistance
    By gosox25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2010, 11:04 PM
  3. Conditional Formatting time comparison w/ =NOW()
    By khamplex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2010, 03:27 PM
  4. Conditional Formatting Assistance
    By Bret in forum Excel General
    Replies: 7
    Last Post: 10-08-2008, 01:39 PM
  5. [SOLVED] Conditional Formatting Assistance
    By JimMay in forum Excel General
    Replies: 4
    Last Post: 05-15-2006, 06:15 AM

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