The function  worked for me. (I am using Excel 2003)

When you place =ColorFunction in your cell, there are two parts. The
first part, is the cell which has the background color that you want to
match. In my instance, cell K1 had the appropriate color. The second
part is the range of cells which should be looked at. In my instance,
H1:H1472. The returned value is the number of cells which match the
appropriate color. If you picked on a cell with no background color,
it may look as though all your cells are being returned to you.