Excel: if duplicate cell value found in another column then highlight green

microsoft-excel formatting cells duplicate

I'm not too good in conditional formatting, but it seems that you will have to use a formula which can lookup the values of column D in column A. A simple one is MATCH.

=MATCH(A1,D:D,0)

The 0 means that exact match, you'll most of the time prefer this over the other options.

Put that in the formula box and pick your formatting.

Make sure you have selected the whole column A before applying the conditional formatting.

Related

Prevent a change to one or more Windows 10 registry key(s) [closed]
How do I un-hide tools in WSCC
How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?
Sharing a printer over a LAN without making a guest account
How to disable Google Chrome tab preview on hover?
How can I add a file to iTunes, from the command line, without playing the file
USB devices not detected unless clicked on scan for hard changes in device manager after enabling Virtual Machine Platform or Hyper-V in Windows 10
How can I write a script to count files modified within a particular month?
What technology to use for home network
How to count the number of times a character appears in a SQL column?
How to get the name or signature of the current method into an NSString?
Hashing in SHA512 using a salt? - Python