a) Data Validation
b) Conditional Formatting
c) AutoFormat
d) Data Sorting
Show Answer
b) Conditional Formatting
Show Answer
b) Conditional Formatting
In Microsoft Excel, you can use the “Conditional Formatting” feature to create rules for formatting cells based on their values. Conditional Formatting allows you to apply various formatting options, such as changing the font color, fill color, or adding data bars, color scales, or icon sets to cells based on specified criteria or rules. This feature is useful for highlighting important data or patterns within your Excel spreadsheets.