Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2010 - Calculation by cell background color

Posted on 2014-08-01
2
Medium Priority
?
287 Views
Last Modified: 2014-08-01
Dear Experts,

Can you please have a short look on the attached example, basically got a file which needs a calculation around:

- if in range columns B to E any value can be found with green background color in the certain raw, then that cell value should be entered to column F (I entered manually the results in the example to column F)

Printscreen
Is that possible by Excel formula or maybe just by VBA?

Best Regards,
Zsolt
CalcByBgColor.xlsx
0
Comment
Question by:csehz
2 Comments
 
LVL 21

Accepted Solution

by:
Randy Poole earned 2000 total points
ID: 40233990
Here you go, added a module to your project and showed you how to call it.
CalcByBgColor.xlsm
0
 
LVL 1

Author Closing Comment

by:csehz
ID: 40234008
That is an amazing way to do it, thanks very much
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

773 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