Conditional Formatting to Highlight if Comma is Found

[0267Kim]

I have a Conditional Formatting question. Suppose I have a column of dollar amounts(Column G with a General number format. Is there a way I can use Conditional Formatting to highlight any amounts which include a comma? I've tried data validation as well. Just can't seem to get Conditional Formatting to work unless I convert the amounts to text.

 

[Toadstool]

Hi 0267Kim,

None of you example cells contain a comma so are you just trying to highlight cell with thousands or more values?

If so then try

0267Kim.xlsx
	F	G
2	T Date	Amount
3	4/4/2020	333
4	4/4/2020	444
5	4/4/2020	555
6	4/4/2020	6.66
7	4/4/2020	777
8	4/4/2020	1000
9	4/4/2020	22222
10	4/4/2020	321
11	4/4/2020	999.99
12	4/4/2020	1200
13	4/4/2020	554433
14	4/4/2020	22
15	4/4/2020	-1299
16
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G3:G99999	Expression	=OR($G3>999.99,$G3<-999.99)	text	NO

 

[0267Kim]

Thanks for the response. No, I'm not trying to highlight cells with one thousand or more. Instead, what I am hoping to do is use conditional formatting to highlight all cells in column which include a comma. I'm attaching a mini sheet. Hopefully, this is a little more clear. There are multiple cells with amounts over one thousand. I only want to highlight those which include a comma.

Book10.xlsx
	A
1	AMOUNT
2	132431.15
3	132,034.15
4	466085.59
5	67303.91
6	57,948.73
7	57251.05
8	37972.12
9	27050.42
10	259949.35
11	5711.51
12	115242.99
13	13738.73
14	1,391.27
15	369837.18
16	318495.83
17	178397.8
Sheet1

 

[kweaver]

How about this?

 

[0267Kim]

Yeah! That worked, thank you so much!

Book10.xlsx
	A
1	AMOUNT
2	132,431.15
3	132034.15
4	466,085.59
5	67303.91
6	57948.73
7	57251.05
8	37972.12
9	27050.42
10	259949.35
11	5711.51
12	115242.99
13	13,738.73
14	1391.27
15	369837.18
16	318495.83
17	178397.8
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A17	Expression	=","=LEFT(CELL("format",A2),1)	text	NO

 

[0267Kim]

Hey, thanks again for the assistance. I had a followup question as well: How can I amend the function above to highlight any comma in any cell in the column? As an example, I've erroneously added a comma to the wrong place in Cell A6.

Book10.xlsx
	A
1	AMOUNT
2	132,431.15
3	132034.15
4	466,085.59
5	67303.91
6	5794,8.73
7	57251.05
8	37972.12
9	27050.42
10	259949.35
11	5711.51
12	115242.99
13	13,738.73
14	1391.27
15	369837.18
16	318495.83
17	178397.8
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A17	Expression	=","=LEFT(CELL("format",A2),1)	text	NO

 

[kweaver]

This might do it:

=OR(ISTEXT(A2),","=LEFT(CELL("format",A2),1))

 

[0267Kim]

And Just Like that, it works! Thank you again for the help! Yall rock!

Book11.xlsx
	A
1	AMOUNT
2	132,431.15
3	132034.15
4	466,085.59
5	67303.91
6	5794,8.73
7	57251.05
8	37972.12
9	27,050.42
10	259949.35
11	,5711.51
12	115242.99
13	13,738.73
14	1391.27
15	369837.18
16	318495.83
17	178397.8
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A17	Expression	=OR(ISTEXT(A2),","=LEFT(CELL("format",A2),1))	text	NO