Ask Your Question
0

Conditional Formating based on matching columns?

asked 2017-04-24 23:52:40 +0100

ForcedLibreUser gravatar image

Hello, I have a list of numbers in column A, names in B, and a secondary list of numbers in C. I am trying to make a conditional formatting formula that will change the text color in B If any of the corresponding numbers in A match C...

I've got $C$2:$C$1000=$A$2 but its not working correctly...Any ideas? Thanks in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-04-25 00:10:05 +0100

Try COUNTIF($C$2:$C$1000;A2)>0

edit flag offensive delete link more

Comments

Thanks, COUNTIF($C$2:$C$1000;A2) worked perfectly...

ForcedLibreUser gravatar imageForcedLibreUser ( 2017-04-25 00:48:39 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-24 23:52:40 +0100

Seen: 19 times

Last updated: Apr 25 '17