Trying to exclude cells based on colour

[Kevin]

Hi

Am trying to do an average of a row of entries but I want to exclude any numbers that are not in normal black text. I think you can use visual basic but am really quite clueless.

Please help
Thanks

 

[bobhc]

Good day Kevin welcome to the forum if you have not already done so please take a moment to read this link it will help you

http://chandoo.org/forum/forums/new-users-please-start-here.14/


These links may be of use to you in answering your question.

http://stackoverflow.com/questions/...es-of-text-in-excel-based-on-background-color

http://www.reddit.com/r/excel/comments/1jzmug/sum_based_on_cell_color/


.