only bold where ever we have letters

[sksanjeev786]

Hi Team

I need only bold data and letter where ever we have this combination ie. (95 CDE, 33 AB)

95 CDE	94 CE	92	93	92
92	94	93	93	92
27	29	33 AB	32 AB	34 AB

Thanks in advance.
Regards,
sanjeev

 

[JamesCanale]

MrExcelPlayground.xlsm
	A	B	C	D	E
1	95 CDE	94 CE	92	93	92
2	92	94	93	93	92
3	27	29	33 AB	32 AB	34 AB
Sheet48

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:E3	Expression	=COUNT(A1)=0	text	NO

 

[sksanjeev786]

MrExcelPlayground.xlsm
	A	B	C	D	E
1	95 CDE	94 CE	92	93	92
2	92	94	93	93	92
3	27	29	33 AB	32 AB	34 AB
Sheet48

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:E3	Expression	=COUNT(A1)=0	text	NO

Simply Awesome Jame

Thank you
Sanjeev

 

[sksanjeev786]

Simply Awesome Jame

Thank you
Sanjeev

Hi Jame

I am not able to do belwo data from A7 to E9 bold to letters

book2
	A	B	C	D	E
1	92 CDE	92 CDE	88	87	90 D
2	86	89 AC	86	88	89 AC
3	22	22	25	27 AB	31 ABC
4
5
6
7	92 cde	92 cde	88	87	90 d
8	86	89 ac	86	88	89 ac
9	22	22	25	27 ab	31 abc
Sheet1

Cell Formulas
Range	Formula
A7:E9	A7	=LOWER(A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A7:E9	Expression	=COUNT(A7)=0	text	NO

 

[JamesCanale]

Nothing is a number when you use the "LOWER" formula. So COUNT always returns a zero - so it is all bold.

try this:

MrExcelPlayground.xlsm
	A	B	C	D	E
12	95 cde	94 ce	92	93	92
13	92	94	93	93	92
14	27	29	33 ab	32 ab	34 ab
Sheet48

Cell Formulas
Range	Formula
A12:E14	A12	=LOWER(A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A12:E14	Expression	=COUNT(VALUE(A12))=0	text	NO

 

[sksanjeev786]

Nothing is a number when you use the "LOWER" formula. So COUNT always returns a zero - so it is all bold.

try this:

MrExcelPlayground.xlsm
	A	B	C	D	E
12	95 cde	94 ce	92	93	92
13	92	94	93	93	92
14	27	29	33 ab	32 ab	34 ab
Sheet48

Cell Formulas
Range	Formula
A12:E14	A12	=LOWER(A1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A12:E14	Expression	=COUNT(VALUE(A12))=0	text	NO

Thanks you so much James