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


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,

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jemagnussenAuthor Commented:
Should say that I work in both Excel 2000 and 2003.
jemagnussenAuthor Commented:
New to this forum, this question should probably have been placed under VBA... sorry...
In excel, try th Menu. Format>Conditional Formatting... and tell it what you want.
Someone in the Excel TA would answer this in about three seconds...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.