What does the green shade mean? Why is a cell shaded green? If the cells are
shaded green using conditional formatting then you can use the same logic
that applies the cf to also count those cells.

--
Biff
Microsoft Excel MVP


"dwake" wrote in message
...
I am trying to do a count of a column....problem is....I want to count
whether the cell is shaded in green and if there is a date in the cell as
well. so if a cell is shaded in green and has a date, that would count as
one. Any ideas?