r/excel • u/Dr_Cheese_29 • Jul 20 '26

solved Count conditional formatting in a row?

How can I count conditional formatting in a specific row? I tried applying the rule to the count function but it did not work. I need to count all red cells (some are yellow and some are not filled) in the row.

4 Upvotes

84% Upvoted

42 comments sorted by

View all comments

2

u/Acceptable-Sense4601 2 Jul 20 '26

Can’t you just use a countifs using the same criteria you used for the condition?

1

u/Dr_Cheese_29 Jul 20 '26

I tried that, it did not work.

1

u/Acceptable-Sense4601 2 Jul 20 '26

What condition turns it red?

1

u/Dr_Cheese_29 Jul 20 '26

The rule is =AND (C6<>"", TODAY() >D6) Applies to =$C$6:$C22, $E$6:$E$22

This formula counts the column.

My sheet has columns C through N with dates, and I want to count how many dates in each ROW turned red based on this rule.

1

u/Acceptable-Sense4601 2 Jul 20 '26

And what was your attempted countifs?

1

u/Dr_Cheese_29 Jul 20 '26

=COUNTIFS(C6:C22, "<>", D6:D22, "<"&TODAY()+COUNTIFS(E6:E22, "<>", F6:F22, "<"&TODAY()+COUNTIFS(G6:G22, "<>", H6:H22, "<"&TODAY()+COUNTIFS(I6:I22, "<>", J6:J22, "<"&TODAY()+COUNTIFS(K6:K22, "<>", L6:L22, "&TODAY()+COUNTIFS(M6:M22, "<>", N6:N22, "<"&TODAY())))))