I want to define a function that can sum all cells' value and then return the color of sum number
For example, A1:A10 is 1 to 10, the sum of A1:A10 is 55, and at the same time the interior color of another cell would change to the color that the colorindex
and I input the function "=iSumColor(A1:A10, B1)" in any cell, the cell should be 55, and the B1 cell's color should be color of index is 55, how do I do it?
Please Login or Register to view this content.
what's wrong with my syntax?
Last edited by bryansky; 03-26-2013 at 01:25 AM.
Hi
Firstly
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
A function should only be used to return a result, not make a change to anything on the sheet. In this case, you are making a change to a cell format, so you should be using a sub.
Try the code below. When it runs, you will be asked to highligh a range. Select the range A1:A10, and continue.
ryloPlease Login or Register to view this content.
Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks