title: Fill and Border color property of data point marker (scatter or line) Excel VBA
body: <p>I am writing some code to loop through each data point in a chart and change the color (fill/border) of the point marker if it is the wrong color. I don't want it to change if it is a compliant color (using a select case). </p>
  
  <p>Problem: Checking markerbackgroundcolor and markerforegroundcolor returns "-1" no matter what the color is until i manually change the color (right click marker and change fill from automatic to solid).Something to do with Automatic colors.</p>
  
  <p>Basic example in immediate window (after inserted scatter chart without changing formatting):</p>
  
  <pre><code>?Activechart.SeriesCollection(1).points(1).markerbackgroundcolor
  returns 
  -1
  </code></pre>
  
  <p>Then without doing anything else:</p>
  
  <pre><code>Activechart.SeriesCollection(2).points(1).markerbackgroundcolor=255
  ?Activechart.SeriesCollection(2).points(1).markerbackgroundcolor
   255 
  </code></pre>
  
  <p>Is there another property of the marker I can test instead? Or another approach entirely? The checking of the color itself is critical to other parts of the code so all the work arounds I've tried so far are not cutting it : (</p>
  
  <p>PS new user, apologies if haven't formulated question too well.</p>