Another one on a Count formula

[sooze29]

Can you use a count formula to count how many cells are filled with a particular fill colour?

Many thanks

 

[SkipVought]

Hi,

There are several FAQs in this forum that address this topic.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

Not without VBA - there is no native functionality for this in Excel.

But if there is any logic behind why each color is assigned to a cell, you can probably use that logic to count.

If you'd like to pursue a VBA solution, please post a new thread in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.