exceldebuggingconditional-formattingdouble-quotesdecimal-point# How to deal with double quotes in conditional formatting's formula

I was having a look at this question, and in order to help, I wrote a conditional formatting rule, based on this formula:

```
="ABS(B3-A3)>=1,5" // the double-quotes are automatically added by Excel
```

This, however, seems not to work, although the formula seems to be correct (in the cell at the right, I asked whether this was true and I got a positive result, as you can see (`WAAR`

is Dutch for true)):

I'm not interested in the final solution, I just want to know how I can debug such a situation: apparantly the formula is true, but still the conditional formatting is not applied. This might mean that:

- Something is wrong with the language settings.
**Something is wrong with the dot/comma decimal separator.**- Something else is wrong with the formula (absolute references, relative references, ...)

How can I, step by step, evaluate the formula, entered in a conditional formatting configuration, in order to see what might be wrong?

Thanks in advance

Solution

Sorry, guys, but the truth is really nerve-wrecking:

- The answer of Error 1004 is correct. Thanks for the screenshot.
- The answer of Jario is correct too.

So what's the deal?

Apparently there seems to be a problem with the decimal separator : when I enter a dot, using Excel regularly, it gets converted into a comma. When I enter a dot in a conditional formatting formula, this conversion is not done, resulting in a wrong formula, where Excel automatically adds double quotes. As the double quotes result in a wrong formula, the conditional formatting won't be applied.

So:

**From the moment you see double quotes in a conditional formula, this is an indication that something's wrong, and that your conditional formatting won't work!**

- Registering COM Object on Windows 64-bit For Use In Excel-32 Bit Is Failing
- Shift data in excel Sheet to left to remove empty cells and include Header names
- If statement in Worksheet_Change not working with On Error Resume Next
- is there a excel formula which will give me the highest year from column F, corresponding to every company code in column c
- Parse Full Name Into Parts
- Transfer data to other sheets/ranges based on dropdown menu on home page
- Excel formula to check a text value from a cell against table's first column and return a value from the table second column
- Excel Multiple Ranges - need different answers for each range (step function)
- VBA Workbooks stop working with upgrade to Excel 365 - VBA Compiling Issue?
- How can I search a range of multiple rows and columns for a value and return it's header?
- If File = "False" Application.GetOpenFileName Error 13 Type Mismatch
- Calculating percent error of each element of a list given a list of ratios
- SWITCH Function with multiple hits - Power Query
- Recursive Lambda to join full parent-child hierarchy
- Excel Conditional Formatting with PowerShell
- How to sort an Excel array in place
- No Such Interface supported while copying worksheets from source Workbook to destination Workbook - Excel VSTO Addin
- Excel formula for complex 2d table sum
- Export Word document as PDF using Excel VBA
- Lookup multiple criteria from column 2 in a table and return the value in column 1 if all match
- Why is the page header not saved when I save and close a workbook?
- ADODB recordset recordcount always returns -1
- Sum cell values below until a blank cell with Python
- VBA empty rows getting filled after running code
- Laravel Excel upload and progressbar
- FileSystem.FileCopy vs objFSO.CopyFile
- Excel VBA: Private Sub procedure too large
- VBA Checkbox combination enables not right?
- Excel macro works on one file, but not for multiple files when looping through a folder
- ASP.NET MVC FileResult is corrupting files