| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting coloured cells
I have a list of percentages that are conditionally formatted and I want to
be able to count how many cells are each different colour. I don't think you can do this with count if as it only looks for numbers or text and not formatting but essentially I want to count the number of cells in a range which are red/gold or green. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with a specific background colour | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Worksheet Functions | |||
| complex fomula: counting cells that are blank | Excel Worksheet Functions | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
