Countif by Color

bcally15

New Member
Joined
Dec 7, 2005
Messages
2
Probably a lay up for someone here but how would I write a countif if formula if criteria was based the color of the cells in my range?
thanks
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top