Thank you for the response.
Sincerely apologise for not taking time to read the Forum Rules. Is it possible to edit the title thread?
Yes, conditional formatting seems to do the work, however what I want to achieve is get the Excel to find cells that are the same as the ones I control-selected within a range, if that makes sense. And subsequently colour them the same. I mean I could do this one by one using the conditional formatting but I'm looking to do this in one go or a simple function. I believe the other way would be utilising the filtering tool.
If VBA is not required which I understand, where do you think I can utilise it? And I mean for automation and if you have other suggestions that would be great? So the best way to learn VBA?
And for the remaining objectives, how do I then get Excel to do: if colour of cell is red then store the numeric values subsequent to it (or maybe say two cells next to it) and then add those values?