Hi all,
I'm using the following formula and I will like the apply to all lines

If Cell A1 has "New Date" highlight all line from B1:Q1 with colour red.
I'm struggling to make it for all as at the moment I have to build the conditional formatting for all cells.
I've tried $A:$A="New Date" to be applied to "$B:$Q" but it highlights all cells even if A10 doesn't match.
What do I do wrong?
Thank you