You want to highlight numbers between 11 and 30 in a range of cells in yellow colour. Which of the following commands in MS Excel 2010 helps you visually highlight important values in your worksheet?
A
Conditional Formatting command
B
Sort command
C
Filter command
D
Format command
Correct Option:
A
Explanation
Conditional Formatting automatically changes a cell's appearance when its value meets specified criteria. For example, a rule can highlight every number between 11 and 30 with a chosen fill colour, making significant values easy to spot.
