Conditional Formatting - Excel 2010

Exprerts,

I have a spreadsheet that I am doing conditional formatting.  The number of rows may vary on subsequent rows.  
Example:
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)
0
 
Angelp1ayConnect With a Mentor Commented:
Conditional formatting based on formula:
=IF($V1="X",TRUE,FALSE)

Open in new window

0
 
NBVCConnect With a Mentor Commented:
If the rows are added just below, then I thing the applied range should auto expand....
0
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.