Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I'd like column P to be highlighted when:
My formula doesn't work:
=COUNTIFS(A6:A, "x", E6:E, "approved", O6:O, "<"&today(), P6:P, "", Q6:Q, "")
try this one by entering it into desired cell at 6th row and expanding the range (eg. P6:P):
=COUNTIFS(A6, "x", E6, "approved", O6, "<"&today(), P6, "", Q6, "")
Required, but never shown