Computer Science, asked by Balinder4509, 1 year ago

Conditional formatting highlight duplicate name in sheet

Answers

Answered by tushar2686

Select the range of cells you wish to test. One way to do so is to click on a single cell and then press Ctrl-A. On Excel's Home tab, choose Conditional Formatting, Highlight Cells Rules, and then Duplicate Values. Click OK within the Duplicate Values dialog box to identify the duplicate values.

Hope you get your answer!

Mark me as

Previous Question

Next Question

Similar questions

Math, 7 months ago

1) cm, Radius of beaker (r) = Height of beaker (h) Volume of beaker =ar2h cm 2) cm3 ml. 3) Volume of water in measuring cylinder cm3 [1ml = 1cm]...

Math, 7 months ago

High cholesterol in blood is a cause of concern as it blocks blood vessels. This inturn causes heart disease. A group of medicines- statins are prescribed by doctors to lower blood cholesterol. Scientists wanted to study the effectiveness of a new statin. For this, a group of 700 men and women with high cholesterol were chosen randomly. The study was undertaken over 8 months with the main...

English, 7 months ago

একজন দেশ প্রেমিক নাগরিকের ১০ টি গুন...

Physics, 1 year ago