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.

Conditional formatting based on column of values
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Conditional formatting if two cells match ✓ - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Based on the values in cells b77 b81 ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

help me to add particular cells

How to use conditional format based on text?

Highlight cell if another cell contains specific text

How do I change a base location on Instagram?

Auto generate serial number in excel based on Column

Similar discussions

Subscribe To Our Newsletter!