Conditional Formatting degree's w/Tolerance

[AFoxExcel]

Hey all first time posting.

I am working on a document, and need to be able to conditional format numbers, and degree's, along with a +/- tolerance. I was able to get the regular numbers to work, but the fomratting does not seem to work when the degree symbol is added.

Any suggestions on how to get conditional formatting for degree numbers?

The formula I am using current is the first image below:

This is an example of what the sheet looks like:

Any help would be appreciated.

 

[Fluff]

You've got an A24 in the formula rather than G24

 

[AFoxExcel]

@Fluff, o yikes... I should have seen that! This all seems to work well now!!

Thank you very much for solving this for me

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dossfm0q]

there are no inconsistencies.

Fluff Formula​

المصنف1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
23	normal Dimension	÷Tolerance	-Tolerance			Part1	Part2	Part3	Part4	Part5		Part1	Part2	Part3	Part4	Part5
24	90°	1°	1°			91°	90°	89°	91°	91°		91°	92°	89°	91°	91°
25	1.000	0.010	0.010			0.901	1.020	1.010	1.030	1.001		1.010	1.020	1.010	1.030	1.010
26	90°	1°	1°			77°	90°	88°	91°	91°		91°	92°	89°	91°	91°
ورقة1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G24:Q26	Expression	=AND(G24<>"",OR(SUBSTITUTE(G24,CHAR(176),"")+0>SUBSTITUTE($B24,CHAR(176),"")+SUBSTITUTE($C24,CHAR(176),""),SUBSTITUTE(G24,CHAR(176),"")+0<SUBSTITUTE($B24,CHAR(176),"")-ABS(SUBSTITUTE($D24,CHAR(176),""))))	text	NO

 

[Fluff]

We've already sorted that out. See post#11