LinkBack URL
About LinkBacks
hello guys,
Is it possible to have a forumlae based on cell color, background being green,
I tried searching online. they always give confusing vb editor codes.
Thats why i need a simple forumlae with color being green
Best Rgds
AT
hello guys,
Is it possible to have a forumlae based on cell color, background being green,
I tried searching online. they always give confusing vb editor codes.
Thats why i need a simple forumlae with color being green
Best Rgds
AT
Hi Brand,
You can have it but for that you must need one helper column (assuming you are formatting cell based on some value and then you want other cell to change as per color formatting).
Regards,
Anil
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
No. Colour is not data. That's why people have developed VBA routines.
You can filter by colour and SUBTOTAL will exclude hidden row so you could maybe use that as a workaround.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
No formula will do that. You can use Autofilter and filter by color and then use SUBTOTAL(109.
If that's not good enough then this UDF will do it for you. Once you pasted the code it will be just like a new function in your workbook.
http://www.ozgrid.com/VBA/Sum.htm
Just post again if you have trouble with UDF and you will get guidance.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
How the cells are formatted?
Manually or Using Conditional Formatting?
If the formatting is not manual then surely we can Sum() the data
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Is there any UDF to add value to cell based on its color? not sum but to add the value to cell.
Thank you,
TA
Hi jacc,
I want to use sum by color function, So I am using attached function.
When i run it, it shows an error
Please chk n let me know
Thanks
AT
I am facing attached error
Hi sixth sense,
The formatting is done on manual basis, pls suggest ur solution
Rgds
AT
@ Anh
Please read the forum rules carefully. You can not post question on someone else's post
Forum Rules
Please read and adhere to these simple rules!
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
Also, please continue with your open threads there only you will get answer for your query. . http://www.excelforum.com/excel-gene...und-color.html
As described by other members you have to go for VBA approach only...Originally Posted by brandedadnan
You copied to far down, this part needs to be there as well:
or specifically the top row of it which is where you tell Excel that this is a function. The text preceeded by a ' is just comments made by the author, you can skip that.
Please Login or Register to view this content.
Or AutoFilter and SUBTOTAL as I said earlier.
Thanks Jacc, worked perfectly, I did not know u can add functions to excel as well.
Great learning curve,
Thanks all for ur efforts.
Rgds
AT
''''''''
-----------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks