Conditional Formatting and Quotation Marks...(Aptos Narrow)

[Match12]

With the switch to Aptos Narrow as the default font in Excel I have found I am having issues with conditional formatting in formulas that use Quotation Marks [e.g. =IF(AND(G10<>“OK”, AND(G10<>“NG”,G10<>“N/G”)),TRUE,FALSE)]
The quotation marks that are "curved" do not work in the formulas. “ vs. " The former does not work, that latter does.
I can't for the life of me understand why one quotation mark works while the other does not.
My fix was the change the default font back to Arial...but I wonder if others that use this spreadsheets will have the same issue.

 

[saboh12617]

Hello,
It is very strange you have this issue in Excel. In Word i indeed had to go to
File > options > Proofing > AutoCorrect > AutoFormat as you type
And uncheck the [replace straight quotes with smart quotes], but this option does not exist in Excel.

 

[Peter_SSs]

On a side note, you don't need an IF function with TRUE/FALSE result options and you shouldn't need two AND functions. This logic should produce the same results as shown below.

=AND(G10<>"OK",G10<>"NG",G10<>"N/G")

24 11 24.xlsm
	G	H	I
9		Your formula (with straight quotes)	New formula
10	abc	TRUE	TRUE
11	OK	FALSE	FALSE
12	Tom	TRUE	TRUE
13	NG	FALSE	FALSE
14	Other	TRUE	TRUE
15		TRUE	TRUE
16	N/G	FALSE	FALSE
Sample

Cell Formulas
Range	Formula
H10:H16	H10	=IF(AND(G10<>"OK", AND(G10<>"NG",G10<>"N/G")),TRUE,FALSE)
I10:I16	I10	=AND(G10<>"OK",G10<>"NG",G10<>"N/G")