title: Getting cell value from hidden column
body: <p>I have a large gridview:</p>
  
  <pre><code>&lt;asp:GridView CssClass="hoursGrid" ID="hoursReportGridView" runat="server" AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84"
      BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataSourceID="SqlDataSource2" OnRowDataBound="hoursReportGridView_OnRowDataBound"&gt;
      &lt;Columns&gt;
          &lt;asp:BoundField DataField="Person" HeaderText="Person" SortExpression="Project" /&gt;
          &lt;asp:BoundField DataField="Project" HeaderText="Project" SortExpression="Project" /&gt;
          &lt;asp:BoundField DataField="ProjectType" HeaderText="Project Type" ReadOnly="True" SortExpression="Sprint" ItemStyle-HorizontalAlign="Center" /&gt;
          &lt;asp:BoundField DataField="StoryNumber" HeaderText="Story Number" SortExpression="Story" ItemStyle-Width="6%" ItemStyle-HorizontalAlign="Center" /&gt;
          &lt;asp:BoundField DataField="StoryTitle" HeaderText="Story Title" SortExpression="Story" ItemStyle-Width="20%" /&gt;
          &lt;asp:BoundField DataField="Effort" HeaderText="Effort" SortExpression="Effort" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Task" HeaderText="Task" SortExpression="Task"  ItemStyle-Width="20%" /&gt;
          &lt;asp:BoundField DataField="OriginalEstimateHours" HeaderText="Original Estimate" SortExpression="OriginalEstimateHours" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Monday" HeaderText="Monday" ReadOnly="True" SortExpression="Monday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Tuesday" HeaderText="Tuesday" ReadOnly="True" SortExpression="Tuesday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Wednesday" HeaderText="Wednesday" ReadOnly="True" SortExpression="Wednesday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Thursday" HeaderText="Thursday" ReadOnly="True" SortExpression="Thursday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Friday" HeaderText="Friday" ReadOnly="True" SortExpression="Friday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Saturday" HeaderText="Saturday" ReadOnly="True" SortExpression="Saturday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:BoundField DataField="Sunday" HeaderText="Sunday" ReadOnly="True" SortExpression="Sunday" ItemStyle-HorizontalAlign="Right" /&gt;
          &lt;asp:TemplateField HeaderText="Total" ItemStyle-HorizontalAlign="Right"&gt;
              &lt;ItemTemplate&gt;
                  &lt;asp:LinkButton ID="taskLinkButton" Text='&lt;%# Eval("Total") %&gt;' Visible='&lt;%# Eval("StoryTitle").ToString() != "" %&gt;' runat="server" OnClick="taskLinkButton_Click" /&gt;
                  &lt;asp:Literal ID="Literal1" Text='&lt;%# Eval("Total") %&gt;' Visible='&lt;%# Eval("StoryTitle") == "" %&gt;' runat="server" /&gt;
              &lt;/ItemTemplate&gt;
          &lt;/asp:TemplateField&gt;
           &lt;asp:BoundField DataField="DifferentUsers" HeaderText="DifferentUsers" SortExpression="DifferentUsers" Visible="false"/&gt;
      &lt;/Columns&gt;
  &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>The last boundfield I do not want to show to the user, which is why its visibility is false.</p>
  
  <p>However, I want to change the color of the cell if this invisible cell for the row is > 0:</p>
  
  <pre><code>protected void hoursReportGridView_OnRowDataBound(Object sender, GridViewRowEventArgs e)
  {
      if (e.Row.RowType == DataControlRowType.DataRow)
      {
          if ((e.Row.Cells[16].Text != "&amp;nbsp;") &amp;&amp; (Int16.Parse(e.Row.Cells[16].Text) &gt; 0))
          {
              for (int i = 0; i &lt; 15; i++)
              {
                  e.Row.Cells[i].ForeColor = Color.Black;
                  e.Row.Cells[i].BackColor = ColorTranslator.FromHtml("#fde16d");
              }
          }
      }
  }
  </code></pre>
  
  <p>THis method works fine with the column is visible, but it does not work when I set it to false. How do I achieved functionality without showing the column?</p>