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.
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
