Question

which function can not be performed using the conditional formatting option?
insert icons that visually display the ranking or rating of values in a selected range.
apply conditional formatting to dates that fall within specified date ranges.
use conditional formatting to highlight any duplicate values or data in a worksheet.
use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

Explanation:

Conditional formatting in spreadsheet software (like Excel) is mainly for formatting cells based on data values (e.g., numerical values, dates, duplicates). Language or spelling errors are typically handled by the spell - check feature (which is a different functionality) and not by conditional formatting.

Answer:

Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.