Prev: Indirect function help
Next: Sorting by number of characters
From: tom on 13 May 2010 12:30
Hello All,
In Excel 2003, I am looking for a way to count colored (conditional formated
cells) in a column.

Desired outcome....
Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000

TFTH

From: Ms-Exl-Learner on 13 May 2010 12:43
You can use the same formula which is used in Conditional Formatting for
highlighting the cells. If you might have used the [Cell value] is in
Conditional formatting other than [Formula is] then explain about the
conditions.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"tom" wrote:

> Hello All,
> In Excel 2003, I am looking for a way to count colored (conditional formated
> cells) in a column.
>
> Desired outcome....
> Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000
>
> TFTH
>
From: tom on 13 May 2010 14:01
Thank you for your response, but I can not see to figure out how to manage
your recommendation. Can you provide an example?

TFTH

"Ms-Exl-Learner" wrote:

> You can use the same formula which is used in Conditional Formatting for
> highlighting the cells. If you might have used the [Cell value] is in
> Conditional formatting other than [Formula is] then explain about the
> conditions.
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "tom" wrote:
>
> > Hello All,
> > In Excel 2003, I am looking for a way to count colored (conditional formated
> > cells) in a column.
> >
> > Desired outcome....
> > Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000
> >
> > TFTH
> >
From: Ms-Exl-Learner on 13 May 2010 21:13
How you would have highlighted the cells using the Conditional Formatting?

--------------------
(Ms-Exl-Learner)
--------------------

"tom" <tom(a)discussions.microsoft.com> wrote in message
news:690B00D8-F956-4D28-98F0-46805825C10D(a)microsoft.com...
> Thank you for your response, but I can not see to figure out how to manage
> your recommendation. Can you provide an example?
>
> TFTH
>
> "Ms-Exl-Learner" wrote:
>
>> You can use the same formula which is used in Conditional Formatting for
>> highlighting the cells. If you might have used the [Cell value] is in
>> Conditional formatting other than [Formula is] then explain about the
>> conditions.
>>
>> Remember to Click Yes, if this post helps!
>>
>> --------------------
>> (Ms-Exl-Learner)
>> --------------------
>>
>>
>> "tom" wrote:
>>
>> > Hello All,
>> > In Excel 2003, I am looking for a way to count colored (conditional
>> > formated
>> > cells) in a column.
>> >
>> > Desired outcome....
>> > Counted cells #'s in (A1) where the colored cells are between A:2 and
>> > A:4000
>> >
>> > TFTH
>> >
 | 
Pages: 1
Prev: Indirect function help
Next: Sorting by number of characters