What is Conditional Formatting? Write down the steps to create a conditional formatting rule.
Answers
Answered by
1
Highlight duplicate values with color
Choose the range in which you need to format duplicate values with a color, such as the example of Employee Name here.
On the Home tab, click Conditional Formatting > Highlight Cells Rules > Duplicate Values.
Select a format from the options drop-down list, then click OK.
Choose the range in which you need to format duplicate values with a color, such as the example of Employee Name here.
On the Home tab, click Conditional Formatting > Highlight Cells Rules > Duplicate Values.
Select a format from the options drop-down list, then click OK.
Answered by
7
Answer:
It is the way to apply color to cell's font and background depending on the conditions set..
Similar questions