Ask Your Question

Conditional Formating based on matching columns?

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

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

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

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

edit flag offensive delete link more


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

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

Question Tools

1 follower


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

Seen: 20 times

Last updated: Apr 25 '17