Solved

Excel 2010 - Calculation by cell background color

Posted on 2014-08-01
2
275 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
Randy Poole earned 500 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel + CountIfs + two colums 5 40
Excel Add-in Subscript out of range 5 32
Problem to macro 5 24
need to query data with cero 6 11
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

710 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