Change of interior color, based on some calculations...

Posted on 2004-11-04
Last Modified: 2011-09-20

I have a fairly large spreadsheet, where the hours used on a constrution project is calculated. Each activity has a certain amount of hours available, and each month the actual hours spend will be entered in a cell under that month. In order to check is hours spend runs over the budgettet, it would be very nice if the backgroundcolor of cells would change accordingly. Say have a nice light green as long as the added values over the months (could be a range("D10:DD10") is less than the estimate, say "C10". When a number is entered in a given month, and it is less tan or equal to "A10" then light green. This should be static, no later changes... If the hours entered for a given month, added to the previous months is more than the estimate, then the background color should change to a faded red. This way there would be a nice overview over hours entered i the months (Jan-05 in column D, Feb-05 in column E... etc.) under the various activities listed in column B.
I can change colors, but have difficulties with having this done based on values as a result of calculations.

Hope somebody can help...

Thanks in advance,

Question by:jemagnussen

    Author Comment

    Should say that I work in both Excel 2000 and 2003.

    Author Comment

    New to this forum, this question should probably have been placed under VBA... sorry...
    LVL 10

    Assisted Solution

    In excel, try th Menu. Format>Conditional Formatting... and tell it what you want.
    LVL 16

    Accepted Solution

    Someone in the Excel TA would answer this in about three seconds...

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now