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
 
Top