title: Can I modify column cell text from a gridview based on a value from a column that isn't displayed in the gridview?
body: <p>I have an asp gridview  that I want to change the color of text on cells based on  values from the column titled "Completed" from the database but I don't want that column to be included in the gridview.  </p>
  
  <p>I want three columns displayed in the gridview:
  User|Form#|Department</p>
  
  <p>If the form is marked as not completed in the database, the column cell for Form# text will be red.</p>
  
  <p>I have this working right now by adding the column I don't want displayed in the gridview so it looks like this:
  User|Form#|Department|Completed</p>
  
  <p>In the SQLdatasource I have query: </p>
  
  <pre><code>Select User, Form, Dept, 
  CASE Finished
  WHEN 'True' THEN (' ')
  WHEN 'False' THE ('!')
  END AS Finished FROM Test1
  </code></pre>
  
  <p>In codebehind:</p>
  
  <pre><code>           if (Completed == "True")
              {
                  cell3.ForeColor = Color.Red;
              }
  </code></pre>
  
  <p>This works but I don't want the column titled Completed displayed in the gridview. Is this possible?</p>