See:

http://www.xldynamic.com/source/xld.CFConditions.html
--
Gary''s Student - gsnu200832


"Dave" wrote:

I have a range of cells that conditional formating will change color when a
cell exceeds a value. Each cell has a different value it will change on. How
do I count for example the number of cells in that range that are colored red
or green by conditional formatting.