True and False including Bold data

[sksanjeev786]

Hi Team,

I am comparing data from F to I and L to O

in H14 i have unbold data and N14 bold data so i should get false. thought hte number are same

FS.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
11	46	53	+7	r			46	53	7	r	TRUE	TRUE	TRUE	TRUE
12	22	34	+12	p			22	34	12	p	TRUE	TRUE	TRUE	TRUE
13	8	16	+8	p			8	16	8	p	TRUE	TRUE	TRUE	TRUE
14	30	28	-2				30	28	-2		TRUE	TRUE	TRUE	TRUE
15	52	61	+9	p			52	61	9	p	TRUE	TRUE	TRUE	TRUE
16	36	52	+15	p			36	52	15	p	TRUE	TRUE	TRUE	TRUE
Sheet1 (2)

Cell Formulas
Range	Formula
F11:H16	F11	=INDEX(INDIRECT("'"&$A11&$B11&"'!A"&$C11&":IV"&$D11&""),MATCH($E11,INDIRECT("'"&$A11&$B11&"'!A"&$C11&":A"&$D11&""),0),F$2)*100
I11:I16	I11	=IFERROR(IF(FIND($W$1,H44),$Y$1),"")&IFERROR(IF(FIND($W$2,H44),$Y$2),"")&IFERROR(IF(FIND($W$3,H44),$Y$3),"")
P11:R16	P11	=ROUND(F11,0)=L11
S11:S16	S11	=I11=O11

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H5:H20	Expression	=I5="p"	text	NO
H5:H20	Expression	=I5="q"	text	NO
H5:H20	Expression	=I5="r"	text	NO

 

[sksanjeev786]

Thanks you so much

It works very well

Hi

I was trying to true and false for bold data i am getting false though i have bold in both the column H11 and Q11

FS.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R
6	6	6	+0			TRUE	TRUE	TRUE		6	6	0
7	80	77	-3			TRUE	TRUE	TRUE		80	77	-3
8	40	42	+2			TRUE	TRUE	TRUE		40	42	2
9	14	18	+4			TRUE	TRUE	TRUE		14	18	4
10	28	27	-1			TRUE	TRUE	TRUE		28	27	-1
11	16	26	+9	p		TRUE	TRUE	FALSE		16	26	9	p
12	18	28	+10	p		TRUE	TRUE	FALSE		18	28	10	p
13	30	40	+10	p		TRUE	TRUE	FALSE		30	40	10	p
14	33	37	+4			TRUE	TRUE	TRUE		33	37	4
15						TRUE	TRUE	TRUE
16	38	44	+6			TRUE	TRUE	TRUE		38	44	6
17	31	38	+7	r		TRUE	TRUE	FALSE		31	38	7	r
18	31	37	+6	r		TRUE	TRUE	FALSE		31	37	6	r
19	30	37	+7	r		TRUE	TRUE	FALSE		30	37	7	r
20	29	37	+8	p		TRUE	TRUE	FALSE		29	37	8	p
21	22	34	+13	p		TRUE	TRUE	FALSE		22	34	13	p
22	201	211				####	FALSE	TRUE		-201	-211
Sheet1 (3)

Cell Formulas
Range	Formula
F6:H14,F16:H21	F6	=INDEX(INDIRECT("'"&$A6&$B6&"'!A"&$C6&":IV"&$D6&""),MATCH($E6,INDIRECT("'"&$A6&$B6&"'!A"&$C6&":A"&$D6&""),0),F$2)*100
I6:I14	I6	=IFERROR(IF(FIND($U$1,H27),$X$1),"")&IFERROR(IF(FIND($U$2,H27),$X$2),"")&IFERROR(IF(FIND($U$3,H27),$X$3),"")
J6:J14,J16:J21	J6	=IFERROR(IF(FIND($U$1,#REF!),$X$1),"")&IFERROR(IF(FIND($U$2,#REF!),$X$2),"")&IFERROR(IF(FIND($U$3,#REF!),$X$3),"")
K6:M22	K6	=FCompare(F6,O6)
I16:I21	I16	=IFERROR(IF(FIND($U$1,H36),$X$1),"")&IFERROR(IF(FIND($U$2,H36),$X$2),"")&IFERROR(IF(FIND($U$3,H36),$X$3),"")
F22:G22	F22	=INDEX(INDIRECT("'"&$A22&$B22&"'!A"&$C22&":IV"&$D22&""),MATCH($E22,INDIRECT("'"&$A22&$B22&"'!A"&$C22&":A"&$D22&""),0),F$2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K6:N22	Cell Value	contains "f"	text	NO
H6:H21	Expression	=I6="p"	text	NO
H6:H21	Expression	=I6="q"	text	NO
H6:H21	Expression	=I6="r"	text	NO

 

[sksanjeev786]

Hi

I was trying to true and false for bold data i am getting false though i have bold in both the column H11 and Q11

FS.xlsm
	F	G	H	I	J	K	L	M	N	O	P	Q	R
6	6	6	+0			TRUE	TRUE	TRUE		6	6	0
7	80	77	-3			TRUE	TRUE	TRUE		80	77	-3
8	40	42	+2			TRUE	TRUE	TRUE		40	42	2
9	14	18	+4			TRUE	TRUE	TRUE		14	18	4
10	28	27	-1			TRUE	TRUE	TRUE		28	27	-1
11	16	26	+9	p		TRUE	TRUE	FALSE		16	26	9	p
12	18	28	+10	p		TRUE	TRUE	FALSE		18	28	10	p
13	30	40	+10	p		TRUE	TRUE	FALSE		30	40	10	p
14	33	37	+4			TRUE	TRUE	TRUE		33	37	4
15						TRUE	TRUE	TRUE
16	38	44	+6			TRUE	TRUE	TRUE		38	44	6
17	31	38	+7	r		TRUE	TRUE	FALSE		31	38	7	r
18	31	37	+6	r		TRUE	TRUE	FALSE		31	37	6	r
19	30	37	+7	r		TRUE	TRUE	FALSE		30	37	7	r
20	29	37	+8	p		TRUE	TRUE	FALSE		29	37	8	p
21	22	34	+13	p		TRUE	TRUE	FALSE		22	34	13	p
22	201	211				####	FALSE	TRUE		-201	-211
Sheet1 (3)

Cell Formulas
Range	Formula
F6:H14,F16:H21	F6	=INDEX(INDIRECT("'"&$A6&$B6&"'!A"&$C6&":IV"&$D6&""),MATCH($E6,INDIRECT("'"&$A6&$B6&"'!A"&$C6&":A"&$D6&""),0),F$2)*100
I6:I14	I6	=IFERROR(IF(FIND($U$1,H27),$X$1),"")&IFERROR(IF(FIND($U$2,H27),$X$2),"")&IFERROR(IF(FIND($U$3,H27),$X$3),"")
J6:J14,J16:J21	J6	=IFERROR(IF(FIND($U$1,#REF!),$X$1),"")&IFERROR(IF(FIND($U$2,#REF!),$X$2),"")&IFERROR(IF(FIND($U$3,#REF!),$X$3),"")
K6:M22	K6	=FCompare(F6,O6)
I16:I21	I16	=IFERROR(IF(FIND($U$1,H36),$X$1),"")&IFERROR(IF(FIND($U$2,H36),$X$2),"")&IFERROR(IF(FIND($U$3,H36),$X$3),"")
F22:G22	F22	=INDEX(INDIRECT("'"&$A22&$B22&"'!A"&$C22&":IV"&$D22&""),MATCH($E22,INDIRECT("'"&$A22&$B22&"'!A"&$C22&":A"&$D22&""),0),F$2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K6:N22	Cell Value	contains "f"	text	NO
H6:H21	Expression	=I6="p"	text	NO
H6:H21	Expression	=I6="q"	text	NO
H6:H21	Expression	=I6="r"	text	NO

Hi

Could you please help me on the above things

as my both data are in bold still i am getting False


Regards
Sanjeev

 

[rlv01]

Hi
Could you please help me on the above things
as my both data are in bold still i am getting False
Regards
Sanjeev

I can't access your data, so that makes it difficult to help you. Your data as posted using XL2BB looks like this:

But when I paste it into my spreadsheet, it looks like this:

Book1
	F	G	H	I	J	K	L	M	N	O	P	Q	R
6	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		6	6	0
7	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		80	77	-3
8	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		40	42	2
9	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		14	18	4
10	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		28	27	-1
11	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		16	26	9	p
12	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		18	28	10	p
13	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		30	40	10	p
14	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		33	37	4
15						#NAME?	#NAME?	#NAME?
16	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		38	44	6
17	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		31	38	7	r
18	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		31	37	6	r
19	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		30	37	7	r
20	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		29	37	8	p
21	#REF!	#REF!	#REF!			#NAME?	#NAME?	#NAME?		22	34	13	p
22	#REF!	#REF!				#NAME?	#NAME?	#NAME?		-201	-211
Sheet1

Cell Formulas
Range	Formula
F16:H21,F6:H14	F6	=INDEX(INDIRECT("'"&$A6&$B6&"'!A"&$C6&":IV"&$D6&""),MATCH($E6,INDIRECT("'"&$A6&$B6&"'!A"&$C6&":A"&$D6&""),0),F$2)*100
I6:I14	I6	=IFERROR(IF(FIND($U$1,H27),$X$1),"")&IFERROR(IF(FIND($U$2,H27),$X$2),"")&IFERROR(IF(FIND($U$3,H27),$X$3),"")
J16:J21,J6:J14	J6	=IFERROR(IF(FIND($U$1,#REF!),$X$1),"")&IFERROR(IF(FIND($U$2,#REF!),$X$2),"")&IFERROR(IF(FIND($U$3,#REF!),$X$3),"")
K6:M22	K6	=FCompare(F6,O6)
I16:I21	I16	=IFERROR(IF(FIND($U$1,H36),$X$1),"")&IFERROR(IF(FIND($U$2,H36),$X$2),"")&IFERROR(IF(FIND($U$3,H36),$X$3),"")
F22:G22	F22	=INDEX(INDIRECT("'"&$A22&$B22&"'!A"&$C22&":IV"&$D22&""),MATCH($E22,INDIRECT("'"&$A22&$B22&"'!A"&$C22&":A"&$D22&""),0),F$2)

I can't work with that and so there is no way I can tell you why you are getting the result you are getting. Only that when I test FCompare on my own data, it produces a correct result for me. You should create a more simple example to illustrate the problem. One that is more portable and self-contained.