Compare one column to multiple columns
Closed
jander
-
Oct 9, 2009 at 12:10 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 12, 2009 at 07:50 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 12, 2009 at 07:50 AM
Related:
- How to compare one column with multiple columns in excel
- Display two columns in data validation list but return only one - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to make multiple selections in photoshop - Guide
- How to change author in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 12, 2009 at 07:50 AM
Oct 12, 2009 at 07:50 AM
Try Putting conditional formatting with formula =COUNTIF($A$3:$A$18,"=" & B3)>0 where B3 is your starting cell and $A$3:$A$18 referes to the data to be checked
