0

Simple one really, how do I highlight cells in column A if their value appears in column B? I found a thread that does the opposite:

Change the color of cells in one column when they don't match cells in another column

Thanks

Community
  • 1
  • 1
nffcevans
  • 1
  • 1
  • 1
  • Yes, simple one really. What have you tried so far? – Gowtham Shiva May 03 '17 at 10:51
  • I've tried the suggestion from http://stackoverflow.com/questions/15396677/excel-compare-two-cell-from-different-sheet-if-true-copy-value-from-other-cell – nffcevans May 03 '17 at 11:08
  • I've also tried the various google suggestions i.e. http://stackoverflow.com/questions/27345379/conditional-formatting-cells-if-their-value-equals-any-value-of-another-column or https://www.ablebits.com/office-addins-blog/2015/08/26/excel-compare-two-columns-matches-differences/ but none seem to just simply highlight a cell if it appears in another column – nffcevans May 03 '17 at 11:15
  • How do you want to compare your data in the columns?? add screenshots if your data here – Gowtham Shiva May 03 '17 at 11:17
  • I can't add screenshots due to confidentiality but it's something like:http://imgur.com/5RXgPrl and I just want to highlight cells in A if they appear in B – nffcevans May 03 '17 at 12:54
  • Is there not a simple way to do this? – nffcevans May 03 '17 at 14:25

1 Answers1

0
  • Select column A
  • Select conditional formatting --> new rule
  • Select "use formula to determine which cells to format"
  • Enter the formula =COUNTIF(B:B,A1)=1 in the formula bar
  • Select a color to highlight and press OK
Gowtham Shiva
  • 3,802
  • 2
  • 11
  • 27