Conditional Formatting Specific Values in a Cell

[ststern45]

Good day everyone,

I would like to as if there is a way to format a range of cell based on a specific value a user selects.

For example, I have 120 cell that contain values. I want to use the 6-7-7 and highlight any cells that match 6-7-7
If a cell contains 2-6-7-7 I would like to highlight this cell
If a cell contains 5-2-2-0-3-6-6-7 I would like to highlight this cell.
If a cell contains 6-6-7-0-5-3-2 I would like to highlight this cell.
I'm not sure if this is possible but only highlight the values 6-7-7.

Thank you in advance

 

[Joe4]

I think you have an error in your description/examples.
Either that, or it isn't quite clear how you want this to work.

Your condition:

highlight any cells that match 6-7-7

Last two examples:

If a cell contains 5-2-2-0-3-6-6-7 I would like to highlight this cell.
If a cell contains 6-6-7-0-5-3-2 I would like to highlight this cell.

These last two examples only have one instance of "7" each, where you rule seems to indicate that they should have two.
Under that rule, it would appear that these two examples should NOT be highlighted.

So what that just a mistake, or do the rules need to be clarified more?

 

[awoohaw]

I dont think you can format portions of contents inside cells with CF. Maybe in VBA you can.
But here is formatting cells that contain a number you can change:

Book1
	A	B	C
1			677
2
3	677	TRUE
4	1018	FALSE
5	1020	FALSE
6	1026	FALSE
7	1096	FALSE
8	1137	FALSE
9	1145	FALSE
10	1150	FALSE
11	1157	FALSE
12	1173	FALSE
13	1186	FALSE
14	1198	FALSE
15	56777	TRUE
16	56778	TRUE
17	106778	TRUE
18	126773	TRUE
19	126779	TRUE
20	156771	TRUE
21	367710	TRUE
22	467716	TRUE
23	467719	TRUE
24	567711	TRUE
25	6771313	TRUE
Sheet3

Cell Formulas
Range	Formula
B3:B25	B3	=ISNUMBER(SEARCH($C$1,TEXT(A3,0)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:A25	Expression	=ISNUMBER(SEARCH($C$1,TEXT(A3,0)))	text	NO

Book1
	A	B	C
1			96
2
3	677	FALSE
4	1018	FALSE
5	1020	FALSE
6	1026	FALSE
7	1096	TRUE
8	1137	FALSE
9	1145	FALSE
10	1150	FALSE
11	1157	FALSE
12	1173	FALSE
13	1186	FALSE
14	1198	FALSE
15	56777	FALSE
16	56778	FALSE
17	106778	FALSE
18	126773	FALSE
19	126779	FALSE
20	156771	FALSE
21	367710	FALSE
22	467716	FALSE
23	467719	FALSE
24	567711	FALSE
25	6771313	FALSE
Sheet3

Cell Formulas
Range	Formula
B3:B25	B3	=ISNUMBER(SEARCH($C$1,TEXT(A3,0)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:A25	Expression	=ISNUMBER(SEARCH($C$1,TEXT(A3,0)))	text	NO

 

[JamesCanale]

I'm taking the dashes seriously, and assuming you don't want to find 6-6-70

MrExcelPlayground22.xlsx
	A
2	2-6-7-7
3	5-2-2-0-3-6-7-7
4	5-6-6-70
5	16-6-7
6	6-7-7-0-5-3-2
7	9-5-2-4
Sheet25

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A7	Expression	=ISNUMBER(SEARCH("-6-7-7-","-"&A2&"-"))	text	NO

 

[ststern45]

Thank you everyone for your help. Each example worked. James your post has the dashes which I also use but I think the ideal solution may be to remove the dashes from my cells.
Thank you
Steve

 

[awoohaw]

Thank you everyone for your help. Each example worked. James your post has the dashes which I also use but I think the ideal solution may be to remove the dashes from my cells.
Thank you
Steve

You wrote in the question:

I would like to as if there is a way to format a range of cell based on a specific value a user selects.

I thought you wanted a user to select the value that is searched? Post#4 does not provide that flexibility.