Color Cell if Cell's Text contains certain Text

[sgexcel321]

Hi, I wish to try to find out how can I color a cell if it contains a certain text.

I have found out how to count when it contains certain texts but I do not understand how to color a cell after much tries.

Below is a snippet of what I am currently doing.

So for example if I have two BRZ which contains either *ZC* or *ZD*, I wish to color the cell at A row 11/12 yellow or something. How do I really do it?.

Thanks, Best Regards

 

[etaf]

use conditional formatting and a formula

=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))

Book1
	A
1	123zcaaa-1
2	123zcaaa-2
3	aa
4	123zcaaa-4
5	aaaa
6	123zcaaa-6
7	aaa
8	AAAAzd-1225
9	aaaa
10	AAAAzd-1227
11	AAAAzd-1228
12	aaaa
13	AAAAzd-1230
14	AAAAzd-1231
15	AAAAzd-1232
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A15	Expression	=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:A500 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[sgexcel321]

use conditional formatting and a formula

=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))

Book1
	A
1	123zcaaa-1
2	123zcaaa-2
3	aa
4	123zcaaa-4
5	aaaa
6	123zcaaa-6
7	aaa
8	AAAAzd-1225
9	aaaa
10	AAAAzd-1227
11	AAAAzd-1228
12	aaaa
13	AAAAzd-1230
14	AAAAzd-1231
15	AAAAzd-1232
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A15	Expression	=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:A500 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=OR(ISNUMBER(SEARCH("ZC",A1,1)),ISNUMBER(SEARCH("ZD",A1,1)))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Hi, is there any way to base on the COUNTIF and then highlighting the cell in column A1? I also wish to count at the same time and I have a lot of different rules to set.

 

[sgexcel321]

Ah I understand how to do it already. For the search ("ZC"), is it better to use search ("*ZC*") or ("ZC"). Does it even matter with the * or no *?

 

[etaf]

search is a function designed to search for the specific text within the cell , so Search("ZC") is already doing the search so no need for the * wild string