Pagine

Excel - Conditional Formatting about duplicates cells

There is an easy Excel feature that permit you to color automatically duplicates cells.

About step by step procedure:

  1. Select Entire Column where you want apply this feature.
  2. CTRL + SPACE.
  3. Home --> conditional formatting --> Highligth Cells rules --> Duplicate values...
  4. At windows prompt select "Duplicate" and "Light Red Fill With Dark Red Text".
  5. Here it is visual result:

Here it is a simple video.