how do i sought coloured number cells from normal ones?

S

sjb1981

i have a spread sheet and and have two different faults being assigned in a
colum and want one to be in one colour and the other in another colour i want
to know how i can get a formula to keep count of how many are in each colour.
 
D

Debra Dalgleish

Instead of counting colours, you can use a COUNTIF formula to count the
number of cells that meet each condition. For example:

=COUNTIF($A$1:$A$21,"Fault1")
 
Top