• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to Automatically Color Duplicate Data Cells in Excel

0 Comments

How to Automatically Color Duplicate Data Cells in Excel: In the process of working with Excel, we often face complex data and sometimes duplicates. One of the common causes of duplication is the habit of copy/pasting data multiple times into a spreadsheet. You need to find and remove duplicate data because just a few redundant data can affect the entire calculation result. So, how can you filter duplicate data in Excel quickly and accurately? This article will help you color the duplicate data cells in Excel to quickly identify the duplicated data cells.

For example, we have a table of the prices of items in 2018 and 2019 as shown below. We want to compare the prices of products that have changed in 2019 compared to 2018 and those that have remained the same. To compare, please follow the steps below.

Step 1

To compare prices between two years, first you need to highlight the entire data to be compared, which are the 2018 Price column and the 2019 Price column in the table.

How to Automatically Color Duplicate Data Cells in Excel

How to Automatically Color Duplicate Data Cells in Excel

Step 2

Next, select the Home tab on the toolbar. Then, choose Conditional Formatting under the Styles section.

How to Automatically Color Duplicate Data Cells in Excel

How to Automatically Color Duplicate Data Cells in Excel

Step 3

The scroll bar appears, select Highlight Cells Rules. Then, choose Duplicate Values.

How to Automatically Color Duplicate Data Cells in Excel

How to Automatically Color Duplicate Data Cells in Excel

Step 4

Now, the Duplicate Values dialog box appears. In the Format cells that contain section, choose Duplicate to highlight the cells with duplicate data. In the Values with section, you can click to choose a color, highlight border. Here are the color options for you to choose from:

  • Light Red Fill with Dark Red Text: Highlight the cell with light red background and dark red text.
  • Yellow Fill with Dark Yellow Text: Highlight the cell with yellow background and dark yellow text.
  • Green Fill with Dark Green Text: Highlight the cell with green background and dark green text.
  • Light Red Fill: Highlight the cell with light red background.
  • Red Text: Highlight the cell with red text.
  • Red Border: Highlight the cell with red border.
  • Custom Format: Choose the color as you wish.

After you have finished choosing, click OK to complete. You can see that the products that have the same price in 2019 as in 2018 are highlighted.

How to Automatically Color Duplicate Data Cells in Excel

How to Automatically Color Duplicate Data Cells in Excel

Step 5

If you want to highlight cells with unique data, simply choose Unique in the Format cells that contain section. Then, click OK to complete. You can see that the products that have different prices in 2019 compared to 2018 are highlighted quickly.

How to Automatically Color Duplicate Data Cells in Excel

How to Automatically Color Duplicate Data Cells in Excel

Therefore, this article has instructed you on how to automatically color duplicate data cells in Excel. Hopefully, this article will be useful for you in the working process. Wish you success!

Rate this post
31
257 Views
How to draw a function graph on Excel extremely simply and quicklyPrevHow to draw a function graph on Excel extremely simply and quicklyMarch 24, 2023
Quickly sort or select random cells, rows, and columns in ExcelMarch 24, 2023Quickly sort or select random cells, rows, and columns in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
Products
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Windows Server 2019 Datacenter Key Global Windows Server 2019 Datacenter Key Global
    Rated 4.75 out of 5
    $7.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Kaspersky Standard - 1 Device, 1 Year (Global License) Kaspersky Standard - 1 Device, 1 Year (Global License) $21.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

00Hours00Minutes00Seconds
Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.

BESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswyBESbswy