Compare one column to multiple columns [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I have a list of values in one column (A) that appear within 5 other columns (B,C,D,E,F). I would like Excel to highlight whenever a value from column A appears in B,C,D,E,F. Any thoughts?

Thanks

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4222 users have said thank you to us this month