2 questions: 1) precision? 2) xl2bb

[yky]

At first, I was wondering if this is a precision question. After pasting the XL2BB data, I have another question about XL2BB. So, there are two questions.
First, XL2bb, this should be a simple question. Why is the format of column E and F TEXT? No matter what the cell format is in the sheet (custom, general, number or accounting), after pasting to this board, it's always TEXT.
Second, this is my real question. Why is the cell E118 red? I set the conditional formatting so that if E118 is not equal to E117 minus C118 plus D118, then the cell should turn red. I have two checking mechanisms, column F and G. Column F just repeats the above calculation and column G checks if column E is equal to column F. You can see in the table that E118 is equal to F118 and G118 confirms it. Yet, conditional formatting doesn't think so. What did I do wrong?

Column C is expense, D income, E balance. They are entered manually and all are integers.

balance.xlsx
	C	D	E	F	G
115	-	26,902.00	706,368.00	706,368.00	TRUE
116	-	42,384.00	748,752.00	748,752.00	TRUE
117	-	11,014.00	759,766.00	759,766.00	TRUE
118	20,000.00		739,766.00	739,766.00	TRUE
tab2

Cell Formulas
Range	Formula
F115:F118	F115	=$E114-$C115+$D115
G115:G118	G115	=E115=F115

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3:F65536	Expression	=$E3<>$F3	text	YES
E:E	Expression	=INT($E2)<>INT($E1)-INT($C2)+INT($D2)	text	YES

 

[bebo021999]

I test in my workbook, choose format Cells/Number/Text:

Book1
	A	B	C	D	E	F	G
15	0	8	8	1		0	1
16	1	0	-1	1		1	0
17	2	1	-1	-1		2	1
18	1	2	1	0.5		1	2
19	-1	0	1	1		-1	0
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G15:G17	Expression	="c15=d15"	text	NO

Below is my CF process:

Try to choose Format Cells/ Fill to colour back ground

 

[yky]

I test in my workbook, choose format Cells/Number/Text:

Try to choose Format Cells/ Fill to colour back ground

My problem is no matter what the cell format is, XL2BB always says it's TEXT. I wonder why XL2BB doesn't says the real format as shown in the sheet. For example, if the format is accounting in the sheet, why doesn't XL2BB says the format is accounting? Why does XL2BB say the format is TEXT?

 

[bebo021999]

Because you are using Conditioning formatting for column E and F. XL2BB told me those column E and F are in "text" format. Try to remove CF, or change it to "Fill" with colour.

 

[bebo021999]

Why E118 red?
I assum that
=INT($E2)<>INT($E1)-INT($C2)+INT($D2)
being created in wrong position (stay in E1)

Try to select cell E2, use this formula and apply to whole range.

 

[yky]

Because you are using Conditioning formatting for column E and F. XL2BB told me those column E and F are in "text" format. Try to remove CF, or change it to "Fill" with colour.

OK. Thanks. Now, I got it. However, when I went to Conditional Formatting, it seemed to say the format is general, not TEXT.

 

[yky]

Because you are using Conditioning formatting for column E and F. XL2BB told me those column E and F are in "text" format. Try to remove CF, or change it to "Fill" with colour.

I tried it again. In Conditional Formatting, I set the format to number. After copying and pasting to this board, I found that it still says the format is TEXT. I then set the format to accounting. Still, it shows up as TEXT. This might be a problem of XL2BB, I guess.

 

[yky]

Why E118 red?
I assum that
=INT($E2)<>INT($E1)-INT($C2)+INT($D2)
being created in wrong position (stay in E1)

Try to select cell E2, use this formula and apply to whole range.

Thanks. That solves the problem.