Hello everyone,
May I ask is excel able to perform any action (mathematics, for example) by identifying the cells or the text colour?
For example, I put a random number between 0 to 100 at cells A1 to A50. After that I format some of the text so the text appears red colour.
Hence, can I ask excel to sum up all the values with black coloured text and minus all the values that appears red in colour?
Hi
Take a look at Bob's site, for this.
http://www.xldynamic.com/source/xld.ColourCounter.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks