Conditional formatting based on column of values

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help me in this.

See below example. The cell color of row 3 &4 from bottom should be changed.
tcp 0.0.0.0:111 9000
tcp 0.0.0.0:22 7913
tcp 127.0.0.1:1976 9001
tcp 127.0.0.1:25 9002
tcp 127.0.0.1:2812 9003
tcp 127.0.0.1:32000 9004
tcp 0.0.0.0:46761 9005
tcp6 :::9000 9014
tcp6 :::7913 9015
tcp6 ::1:8009 9016
tcp6 127.0.0.1:8009 9017

I use Office 2010 Pro.

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Sivanesan,

Select your range (when I pasted your data I got range A1:C11) and apply conditional format. Choose to use a formula:
=COUNTIF($C$1:$C$11,RIGHT($B1,4))

Best regards,
Trowa