title: DataGridView cell BackColor not formatting correctly
body: <p>I have a datagridview in my app which lists active jobs.
  One of the columns has a status code (0-5) and the rows are coloured depending on this value, like so...</p>
  
  <pre><code>     joblist.Rows(e.RowIndex).DefaultCellStyle.BackColor = Color.Aquamarine
       joblist.Rows(e.RowIndex).DefaultCellStyle.ForeColor = Color.Black
  </code></pre>
  
  <p>if the status code is 0 then no colour is applied.</p>
  
  <p>This bit works fine mostly, but I found that if it gets to several jobs with status 0, these jobs take on the colour of the last job which has a status of 1-5.</p>
  
  <p>I can work around this by adding...</p>
  
  <pre><code>     elseif status=0 then
       joblist.Rows(e.RowIndex).DefaultCellStyle.BackColor = Color.Aquamarine
       joblist.Rows(e.RowIndex).DefaultCellStyle.ForeColor = Color.Black
       end if
  </code></pre>
  
  <p>However, that wipes out my alternative rows colour, so if theres a block of white ones, they become hard to read.</p>
  
  <p>Is there a way I can say something like...</p>
  
  <pre><code>  if status=0 then
    joblist.Rows(e.RowIndex).DefaultCellStyle.BackColor = DefaultCellStyle.BackColor
    joblist.Rows(e.RowIndex).DefaultCellStyle.ForeColor = DefaultCellStyle.BackColor
  </code></pre>
  
  <p>... or whatever, to basically return the row in question to the default or alternative default style?</p>