Hi everyone,
Can somebody please help with this ?
I would like to count the coloured cells which have been coloured by conditional formatting.
I have used a macro to count the cells, but I can only get the total to pop up on the screen (which is what I don't want).
I want to be able to have the total show in a cell on the worksheet as I have multiple columns / rows which need to be counted and I need to have them show the totals all at the same time.
Thanks.
Jo.
Can somebody please help with this ?
I would like to count the coloured cells which have been coloured by conditional formatting.
I have used a macro to count the cells, but I can only get the total to pop up on the screen (which is what I don't want).
I want to be able to have the total show in a cell on the worksheet as I have multiple columns / rows which need to be counted and I need to have them show the totals all at the same time.
Thanks.
Jo.