title: Using VBA to detect which decimal sign the computer is using
body: <p>Is it possible to use VBA to detect which decimal sign is being used on the computer?</p>
  
  <p>I have a macro script that adds a conditional formatting to an excel sheet. The problem is that the target computers might use both decimal signs. So I want to make the script work for all computers.</p>
  
  <p>The code looks like this:</p>
  
  <pre><code>With range("D" &amp; row)
      .FormatConditions.Delete
      .FormatConditions.Add Type:=xlCellValue, Operator:=xlNotBetween, Formula1:="=1,01*$C$" &amp; row, Formula2:="=0,99*$C$" &amp; row
      .FormatConditions(1).Font.ColorIndex = 3
  End With
  </code></pre>