Hi,
Any help appreciated. I need a formula that counts a set/range of cells based on color, the cells within range are in different colors, I want the formula to return a value, for example, 3 (number fo yellow cells).
Is this possible)
Regards
Niklas
Don't think you can do it without VBA.
http://www.cpearson.com/excel/colors.htm
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks