Ask Your Question

Conditional Formating based on matching columns? [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-01 13:40:56.929156

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 28 times

Last updated: Apr 25 '17