Google Sheets Conditional Formatting – How to Use COUNTIFS

conditional formattinggoogle sheetsgoogle-sheets-custom-function

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, "")

In Format, Conditional formatting... the following should achieve what you request:

WA58956 example

where "Custom formula is" contains:

=countif(C:C,C1)>1

and Range may be set to C:C - or adjusted to suit.

With the range set to: B3:O1000

Try:

=AND(ISBLANK(B3),INT($A3)=INT(today()))

or even shorter:

=AND(ISBLANK(B3),$A3=today())