Excel COUNTIFS function

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

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
COUNTIF not working
sme527 in Excel on
10 Replies
Finding the data and to color code it
NishantSalunkhe in Excel on
3 Replies
=Function() returning incorrect date in some cells
tom_gowen in Microsoft Teams on
1 Replies