Home

Excel COUNTIFS function

philipperotti
Occasional Visitor

how can I create a function using COUNTIFS that looks for "x" in one row and a conditionally formatted color in a different row to report a count if both are true?

basically, can the function "function" use color as a criteria?

1 Reply
Highlighted

Nope, functions work with values, not with properties like color. However, you may use formulas which are within your conditional formatting rules; or write your own function on VBA

Related Conversations
Matching date input to the formatted date display
Erikstg in Excel on
1 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
13 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies