In this (partially redacted) sheet I want to set rules based on the Q column:
Q is date-formatted but clearly is not blank, so why is the formatting being applied? I've tried other rules like exact text-matching and they don't work either.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityThe formula you need is =ISBLANK($Q2)
By using the $
sign in front of Q2
you lock it and this way you get the conditional formatting applied on the whole range of row on the selected cells.