I have some cells in a worksheet that are conditionally formatted. I need to
count the number of cells that have green text. How can this be done?

Did you use a formula to set the conditional formatting? If so, you can use
that formula (might need a little modification) to count how many cells meet
the criteria.

Use the logic of *why do some cells have green text* to create a formula to
count those cells.


--
Biff
Microsoft Excel MVP


"amy" <(E-Mail Removed)> wrote in message
news:6C56E463-8AD0-4849-8E12-(E-Mail Removed)...
>I have some cells in a worksheet that are conditionally formatted. I need
>to
> count the number of cells that have green text. How can this be done?