M Mark Keeffe Oct 17, 2003 #1 Is it possible to base a criterion for a function like Countif on the fill colour of the cells in the specified range?
Is it possible to base a criterion for a function like Countif on the fill colour of the cells in the specified range?
P Paul Oct 17, 2003 #2 Mark Keeffe said: Is it possible to base a criterion for a function like Countif on the fill colour of the cells in the specified range? Click to expand... This needs VBA code; it cannot be done with worksheet functions. Look here for full details: http://www.cpearson.com/excel/colors.htm
Mark Keeffe said: Is it possible to base a criterion for a function like Countif on the fill colour of the cells in the specified range? Click to expand... This needs VBA code; it cannot be done with worksheet functions. Look here for full details: http://www.cpearson.com/excel/colors.htm