How do you find duplicates in conditional formatting?
- 1 Answers
- 700 Views
- I also Faced
- E-Mail Answers
Answer / Shri Prakash Yadav
To find duplicates in MS Excel using Conditional Formatting, select the data range, go to 'Home' > 'Conditional Formatting', then choose 'Highlight Cells Rules' > 'Duplicate Values'. Choose a formatting style for the duplicate cells.
| Is This Answer Correct ? | 0 Yes | 0 No |
How To Protect The Macros You Create So People Cannot See Or Alter Them?
What is the keyboard shortcut to show all formulas in a worksheet?
How many functions are there in ms excel?
What is the best font to use in excel?
What does a red triangle at the top right of a cell indicate?
when I apply fill pattern to a chart, it looks okay on the worksheet. However, the pattern disappears when I print the worksheet. Whats wrong?
How do I separate data in excel?
What is a scenario model?
How do I create a formula for conditional formatting in excel?
How do you delete a sheet in excel using keyboard?
Why is excel called excel?
Can you do a lookup in excel?
MS Excel Microsoft 
