Hi all,
I have a problem which i hope that some of you might be able to help me with. I have made a VB function that takes both color and text of a cell into account. If both text and color are matched then i need the value of a cell in the same row but in a different colum.
I hope one of you excel wizds can help me...
Please Login or Register to view this content.
thx.
Last edited by Slowfish; 04-18-2012 at 10:46 AM. Reason: Please put code tags in future.
It can maybe also be solved with a variation of the SUMifs function if only it could take colors/formating into account
Last edited by Slowfish; 04-18-2012 at 10:40 AM.
Can no one help??? As you guys might have have noticed I'm kinda new to all this VB stuff, but i really need this to work...
I have have made an example for you guys to see... It might make easier...Example.xlsm
I need to sum the values of a and b accordingly to color coding...
Last edited by Slowfish; 04-18-2012 at 08:49 AM.
Does anyone at least know if it can be done?
try it
Please Login or Register to view this content.
Thanks a lot Nilem!
It seems like it works...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks