R
ruthhicks999
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.
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.