I have a spreadsheet that I am doing conditional formatting. The number of rows may vary on subsequent rows.
If there is an error identified by an "X" in column V, column Q is highlighted in yellow.
I am currently manually inputting to format rows $Q$2:$Q$151. Is there a way I can format so that I don't have to explicitly define each time based on the number of rows.