exclude grey cells in countif

T

tsangkinyip

Hi,

Can anybody tell me how to exclude counting grey cells in a countif
function, for exmaple?

Marco
 
P

Pete_UK

You can't refer to colour formats in a standard function - you would
need a user-defined function (UDF) or a macro for that.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Real-Time Co-Authoring stops working 0
Unwanted line across top of pages; how to delete? 0
Program buttons to create a word document 0
Count Number of Unique Cells That Don't Have Certain Characters 0
How do I exclude a cell from a range? 4
Grey ghost rectangle 2
Exclude Hidden Row Values 4
Excluding a column from range in COUNTIF function 3

Top