PDA

View Full Version : Solved: underline non duplicated values from 2 columns



white_flag
12-08-2011, 11:18 AM
compare two columns
I have the first column (60 rows)
1
3
d5
f8
r7
t4
y5
etc
and the second column (120 rows)

1
31
ds
f8
r4
t4
y5
q5
r9
etc
it is possible to check if the values from the second column can be find in the first column. And if those are not in the first column to become underlined

mdmackillop
12-08-2011, 11:57 AM
You can do this with Conditional Formatting and a formula like
=COUNTIF(B:B,A1)=0

white_flag
12-08-2011, 12:20 PM
it is working like this:
A_____B_____C

12____12____FALSE
hj_____HJ___FALSE
gh_____gh___FALSE
hg_____gh___TRUE
gh_____hg___TRUE

but "hg" exist in column A and exist also in column B (not in the same rowlocation), in my case, I need to check if values from colB are in colA, if theare are NOT, underline

a bit of VBA?

mdmackillop
12-08-2011, 12:24 PM
That is what the suggested solution will do.

white_flag
12-08-2011, 12:36 PM
correct :), my bad, it is working the way I expected
thank you.