morinia
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.