Highlighted Cells

[John Henworth]

Hello
Is there a way of Summing the highlighted cell in a row please

John

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[John Henworth]

Attachment included

[MrChulo]

Hello John,

This should be very possible. I tested to record a macro while changing cell color and there are specific values to check if a cell is highlighted or not. Below would sum all cells that are not highlighted at all.

You just need to define the cells that needs to be checked, loop through them and assign each to the range-variable.. you might want to confirm that the highlighted cell is actually a number

Please Login or Register  to view this content.

[John Henworth]

Hello
Thanks for your reply but it is far to advanced for me
On my attachment the ones I want to add up are the yellow ones

[MrChulo]

Hello John,

Your example does not fit your question....

Do you want to count highlighted Cells containing Home (6) and Away (2) ? or both together (8)?

Is the table dynamic in size? Add as much information as you can.

[John Henworth]

Hello
I can highlight the cells that are correct, what I want is a column to add up the cells I highlight for the correct result
sorry for the confusion

[davsth]

https://www.exceltip.com/custom-func...oft-excel.html

has worked for me in the past, as a function rather than a subroutine that needs to be run