| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif background colour is.....
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Background colour grey on entire worksheet | Excel Discussion (Misc queries) | |||
| Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
| establishing the background colour of a cell | Excel Discussion (Misc queries) | |||
| excel and no background colour | Excel Discussion (Misc queries) | |||
| Conditional format if cell=0 then font colour same as background . | Excel Discussion (Misc queries) | |||
Threaded Mode
