Having trouble with the above, although the two links posted previously were
helpful in how i should do it [cpearson and xldynamix] but I have been unable
to count cells with a specific colour in them.

I think it maybe my inputting of the VBA code as I am not sure I am doing
this correctly. I have just cut and pasted the code from this site into VBA,
but do not know enough about it to ensure this is right. After inputting the
formula code, when I use it, it is not reconised and returns a NAME error.

Can anyone tell me what I am doing wrong and how to correct it?

http://xldynamic.com/source/xld.Colo...r.html#sorting