Conditional formatting based on column of values

Closed
Sivanesan - Apr 14, 2017 at 04:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 25, 2017 at 11:37 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 25, 2017 at 11:37 AM
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
0