count coloured cells

methody

Well-known Member
Joined
Jun 17, 2002
Messages
822
Is there any way of counting the number of cells in a column which are shaded red?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
There should be a way of counting them using the same condition which was used for the conditional formatting, what condition is that?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top