This is a two part question, im working with a dataset and a Grid view. the dataset is populated by querying a database, after this some calculations are done and added to the dataset. once all the calculation are done the dataset is then bound to a grid view. which looks like this.

```
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%"  CssClass="tableText" >
        <AlternatingRowStyle BackColor="White" />
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
        <Columns>
        <asp:BoundField DataField="INV_GP" HeaderText="INV GP" />
        <asp:BoundField DataField="SORG_GP" HeaderText="SORD GP" />
        <asp:BoundField DataField="SRTN_GP" HeaderText="SRTN GP" />
        <asp:BoundField DataField="EXPEND" HeaderText="EXPEND" />
        <asp:BoundField DataField="TARGET" HeaderText="TARGET" />
        <asp:BoundField DataField="PERC_OF_TARGET" HeaderText="%" />
        <asp:BoundField DataField="M_PERC" HeaderText="M%" />
        <asp:BoundField DataField="100NEED" HeaderText="NEED FOR 100%" />
        </Columns>
    </asp:GridView>

```

Here is what I want to be able to do:

1. As you can see of the columns have % values but the data set just has number. How do I display a % next to the number in the gridview?
2. I want to be able to add some sort of conditional statement to be able to display the text in different colours. For example, in the m%, if any of the values is less than 50% i want the text to be shown in red.