Computer Science, asked by Balinder4509, 10 months 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

Physics, 5 months ago

Acceleration of a particle, executing SHM, at its mean position is...

English, 5 months ago

The idea of change in all spheres of existence in the world would lead to ...

History, 5 months ago

what were the 3 kinds of tools used in paleolithic age? dont spam the question please and pleaae dont answer useless answers. like i dont know, sorry etc etc please whoever will give the correct answer i will mark his answee as brainliest and will give 6 thanks...

Physics, 10 months ago