which function can not be performed using the conditional formatting option?\ninsert icons that visually…
which function can not be performed using the conditional formatting option?\ninsert icons that visually display the ranking or rating of values in a selected range.\napply conditional formatting to dates that fall within specified date ranges.\nuse conditional formatting to highlight any duplicate values or data in a worksheet.\nuse conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.
Answer
Brief Explanations:
Conditional Formatting in spreadsheet software is used for formatting cells based on cell - values or other conditions. It can handle value - based ranking (icons), date - based conditions, and highlighting duplicates. However, it is not designed to detect and format language or spelling errors.
Answer:
Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.