I have a macro that I want to use to change the background colour of a cell. Currently it also changes the number in the cell to S for sold and I do a =countif (range,"S"). Is there anyway that I can do the countif so that it will count all of the cells with a specific background colour.

It would also be useful if I was able to sort/filter based on the background colour.

[quote=ruthhicks999] Is there anyway that I can do the countif so that it will count all of the cells with a specific background colour.
QUOTE]

I really like the similar questions feature have followed a previous enquiry which was simialar and found my answer. Thank you.

Send the macro for rectification to

Take a look at

http://cpearson.com/excel/colors.htm

In article ,
ruthhicks999 wrote:

I have a macro that I want to use to change the background colour of a
cell. Currently it also changes the number in the cell to S for sold
and I do a =countif (range,"S"). Is there anyway that I can do the
countif so that it will count all of the cells with a specific
background colour.

It would also be useful if I was able to sort/filter based on the
background colour.