Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi,

Please see the attached file

Can anybody tell me how to count coloured cells in excel,

For example, I have numbers with red , I want to count

how many Red coloured cells are in each line.

thanks

## Similar Excel Video Tutorials

12 Amazing Counting Formulas
- See the functions, FREQUENCY, SUMPRODUCT, COUNTIF, COUNTA, COUNT, ISNUMBER, ROWS, COUNTDIFF, UNIQUEVALUES functions. MoreFunc Add-in

1)Count cell ...

## Similar Topics

Is it possible to count the number of coloured or formatted cells?

I am creating a comparison chart, which will compare different values in a matrix

1 1 1 1 1 1 1 1 1 1 1 1

7 8 9 10 11 12 13 14 15 16 17 18

2 2 2 2 2 2 2 2 2 2 2

8 9 10 11 12 13 14 15 16 17 18

3 3 3 3 3 3 3 3 3 3

9 10 11 12 13 14 15 16 17 18

4 4 4 4 4 4 4 4 4

10 11 12 13 14 15 16 17 18

5 5 5 5 5 5 5 5

11 12 13 14 15 16 17 18

6 6 6 6 6 6 6

12 13 14 15 16 17 18

7 7 7 7 7 7

13 14 15 16 17 18

8 8 8 8 8

14 15 16 17 18

9 9 9 9

15 16 17 18

10 10 10

16 17 18

11 11

17 18

12

18

In each section, one of the numbers will be chosen and either coloured or made bold. Then what I want to do is count all the cells with a number 1 in it which are highlighted or bold (there will be other cells with a number one in it, which are not to be highlighted

The same will be applied to number 2 - 18

Can it be done?

I would really appreciate your help

Thank you

Lynne

Hi,

Can anybody tell me how to count coloured cells in excel,

For example, I have numbers with red and green colour, I just want to count

how many Red coloured cells are there and how many green coloured cells are there?

thanks

Hi,

I`m trying to work out how to have a the cell directly below a cell with data in it coloured and also a certain number of cells below.

So if there is something in B2, I want B2-B3 coloured, if there is something in E20, E21-26 need to be coloured.

The cells already have some conditional formatting on them for something else that cant be changed either, and needs to over-ride this. So if in the second example E23 has data, that cell cant be coloured but the 5 cells below that will be etc.

The number of cells to vertically be coloured will range from 1 to ~60

Have attached image of example, any help would be greatly appreciated.

Hi. Can anyone tell me how in excel 2003 you can count the number of coloured cells in a column.

Many Thanks

Is it possible to do a count of cells that have been coloured red through meeting a conditional formats criteria? The colour is not cell fill colour, but actual cell entry has been coloured red.

Hi

I am trying to find out how I can count the number of blank cells (no colour) within a column.

My colleague has a staff spreadsheet whereby those staff on leave are coloured red, those sick are coloured blue etc etc.

The staff actually available are not coloured, and she needs to be able to count them in a fast fashion. Counting them manually is very time consuming as there are lots of them.

Hope someone can help

Many thanks in advance..

This is a two part question.

I have a column in excel with a combination of different coloured cells. Could anyone advise on a formula to total the number of coloured cells at the bottom of the column?

If I have a recurring word appearing every few cells, can any one suggest a formula to count these?

Any help of advice would be very much appreciated.

Iain.

This is a two part question.

I have a column in excel with a combination of different coloured cells. Could anyone advise on a formula to total the number of coloured cells at the bottom of the column?

If I have a recurring word appearing every few cells, can any one suggest a formula to count these?

Any help of advice would be very much appreciated.

Iain.

I have loads of cells that have been coloured in. How do I sort them so all the coloured cells are together at the top no matter what the numbers are within the cells. The table below should explain better.

I may have loads of data in other columns but I want to sort by coloured cells first.

Thanks

Data
Result Required
1
4
2
7
3
11
4
14
5
1
6
2
7
3
8
5
9
6
10
8
11
9
12
10
13
12
14
13
15
15

Hi,

Wondering if anyone could help me with a formula for the following:

I have a spreadsheet that contains various different coloured cells,

I need to be able to:

1. count the number of cells in a given range that are coloured a certain colour.

2. show the answer of a sum involving the above, i.e in range D1:D:5 the sum of 10 + blue cells, minus yellow cells = 12

eg.

A
B
C
D
1
2
3
4
5
Sum of 10 (plus blue cells minus yellow cells in range D:1 to D:5) should equal 12

Thanks

Jo

I am after some help. I have a spreadsheet with around 1 million rows of data. I need to be able to count the number of cells in a particular column which contain red text.

I have tried the CELL function, but this can only identify cells which are coloured, and not text which is coloured within a cell.

Any help would be gratefully received.

Many thanks

Is there a formula I can use to count how many cells are coloured a particular colour ( let's say green ) between ( let's say ) D3 and Z3

I would like to count how many coloured cells exists in a range:

for example 5 blue, 2 red, 3 yellow,...

Is there any function for this?

Thanks in advance

Hi There,

I was wondering if anyone know a formaula for counting the coloured cells in a conditional formating senario? I have a RAG analysis and would liek to count teh number of amber and red's?

Thanks,

O.T.

Any quick method to give all blank cells in a range a value of "1" with the only differentiating factor being the other cells are coloured, i.e. need to put "1" in all non coloured cells?

Hi, is there any way i can get excel to count the number fo cells in a range which are filled in a certain colour?

i have sheets with red and green coloured cells (simply selected a cell and set fill colour to green or red)

any ideas as this has been bugging me for a while now!?!

I have a spreadsheet with the cells coloured red, yellow, green etc. The cells may or may not have data in them. I wish to count all the red cells, all the yellow etc irrespected of the data that they may contain. Is the a formula that one can use to count the coloured cells?

Hi

I am working on a pivot table with approx. 10,000 rows and 12 columns across.

I have coloured some of the cells red.

I have a counta formula at the bottom of column 1, which counts the number of entries in column 1.

I would like to know if there is a way to count the Red cells in column 1.

Many thanks

J

Hi,

I have had a look through some searches and I can't find any that have answered this question before so would appreciate it if someone could assist.

I have a few cells on a sheet which will be coloured red. They won't always be the same cell references, but they will always be the same colour.

I was wondering if there was some VBA code somewhere which would allow me to put in cell D1 the total amount of the coloured cells.

Please, if you need more info, just ask'

Kind Regards

Jamie

Hi All

I have a feeling that this is a dumb beginners question.

I have a worksheet containing a large column with random coloured (red) cells, how can I Sum only the coloured cells and then only the empty cells?

TIA thalt

All, please excuse me if I have posted in the wrong forum. Am at my wits end.....

I want to do a mail merge into MS Word. The speadsheet I am using has many coloured cells (green) to indicate changes between earlier and upated info.

My questions -

(1) is there any way to perform a mail merge on the info contained only in the coloured cells?

or

(2) is there any way that merged info in the document will be formatted differently (italics, or coloured, or...) to indicate that the data has come from a coloured cell in Excel?

Many thanks, c.

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.

Hi all

I have a sheet with colour coded cells and I need a macro that counts the number of rows with coloured cells.

I've tried the following code but I always get a count of 0 which isn't right.

Code:

Sub Count_Coloured_Cells()
Sheets("Issues").Select
Dim i, c
Dim LastRow As Long
i = 1
c = 0
LastRow = Range("A65536").End(xlUp).Row
Do While i < LastRow + 1
If Rows(1 + i & ":" & 1 + i).Interior.ColorIndex xlNone Then
c = c + 1
End If
i = i + 1
Loop
MsgBox (c)
End Sub

Remember, it's the number of rows I need to count (i.e. one row may have several colour coded cells but I only need to count it once).

Thanks in advance

Hi,

I've got a table which i need to count automatically the number of varying coloured cells.

Could anyone tell me if this is possible for me to say 'count the number of green squares or count the number of red and green squares'

Thanks

Dear Friends,

I have a worksheet where a column B's cells are filled with various colours like RED, GREEN, YELLOW etc.

Now In column C, I want to count the cells which are filled in different colours.

I mean C1 will give the count of GREEN coloured cells, C2 RED, C3 YELLOW.

Is it possible ?

Pls help me.

Regards

RAMU