• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Excel 2010 - Calculation by cell background color

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
csehz
Asked:
csehz
1 Solution
 
Randy PooleCommented:
Here you go, added a module to your project and showed you how to call it.
CalcByBgColor.xlsm
0
 
csehzIT consultantAuthor Commented:
That is an amazing way to do it, thanks very much
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now