'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 1:[1]
- Select the whole range (for the example A2:B5)
- Add in conditional formatting formula
=ABS($B3-$A3)>=1.5
Result:
Solution 2:[2]
Remove the "" at the beginning and end of your formula. Should do the trick.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Error 1004 |
| Solution 2 |