Computer Science, asked by Prajaktap1841, 1 year ago

What is Conditional Formatting? Write down the steps to create a conditional formatting rule.

Answers

Answered by ashi1199
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.
Answered by apekshanegi40
7

Answer:

It is the way to apply color to cell's font and background depending on the conditions set..

Similar questions