Excluding shaded cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Slater - 28 Aug 2007 21:25 GMT

Hi,

I'm using a simple formula to count blank cells:

=COUNTIF(A2:F2,"")

Is there a way to exclude cells that are shaded within a formula?

Thanks,

Mike

Reply to this Message

Niek Otten - 28 Aug 2007 21:31 GMT

<shaded within a formula>

What does that mean?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 7 lines]
|
| Mike

Reply to this Message

Earl Kiosterud - 28 Aug 2007 22:45 GMT

Michael,

If by "shaded" you mean a color fill, the answer is no. Color fill is cell formatting.
Take a look at "Formatting as data" at http://www.smokeylake.com/excel/excel_truths.htm for
some background on this.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 7 lines]
>
> Mike

Reply to this Message

Michael Slater - 29 Aug 2007 00:16 GMT

Yes, that is what I meant. Using color fill as a criteria in a formula. I
will check the link you provided.

Thanks for all replies,

Mike

> Michael,
>
[quoted text clipped - 14 lines]
>>
>> Mike

Reply to this Message

Rate this thread: