Conditional Formatting - Excel 2010


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.
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
Angelp1ayConnect With a Mentor Commented:
Apply that to the whole column $Q:$Q...

Screenshot...screenshot is showing with it applied to Q3... formula above is correct for applying to the whole column (with $V1 instead of $V3)
Angelp1ayConnect With a Mentor Commented:
Conditional formatting based on formula:

Open in new window

NBVCConnect With a Mentor Commented:
If the rows are added just below, then I thing the applied range should auto expand....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.