如何根据不同的ID把字段里的内容标注不同的颜色

举个例子:
<%
  sql="select  * from biao1"
 set rs=conn.execute(sql)
while not rs.eof
  select case rs("id")
  case 1
  response.write "<font color=yellow>"&rs("字段1")&rs("字段2")&...&"</font>"
  case 2
  response.write "<font color=red>"&rs("字段1")&rs("字段2")&...&"</font>"
  case 3
  response.write "<font color=purple>"&rs("字段1")&rs("字段2")&...&"</font>"
  case 4
  response.write "<font color=green>"&rs("字段1")&rs("字段2")&...&"</font>"
  case else
  response.write "<font color=white>"&rs("字段1")&rs("字段2")&...&"</font>"
 end select
  rs.movenext   
 wend
%>
这只是一个普通的例子，具体要怎么样，你还可以更改各种形式的。不知道这样说是否能理解！

谢谢gupiao175！你提供的判断语句我能看得懂但不会运用。用时提示“缺少标识符”
现把代码附上，希望给予帮助：
表：ma2  字段： up1 up2  共有七个ID数。希望每行ID数的内容运用不同的颜色进行标注。(如上图所示)
<!--#include file="conn.asp"--><%
   MaxPerPage=7   
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from ma2 order by id asc"
rs.open sql,conn,1,1
%>
<table border="1" width="100%" id="table1">
    <tr>
        <td>ID</td>
        <td align="center">字段1</td>
        <td align="center">字段2</td>
    </tr>
   
<%do while not rs.eof%>

    <tr>
        <td><%=rs("ID")%></td>
        <td align="center"><%=rs("UP1")%></td>
        <td align="center"><%=rs("UP2")%></td>
    </tr>
</table>

<!--#include file="conn.asp"--><%
   MaxPerPage=7   
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from ma2 order by id asc"
rs.open sql,conn,1,1
%>
<table border="1" width="100%" id="table1">
    <tr>
        <td>ID</td>
        <td align="center">字段1</td>
        <td align="center">字段2</td>
    </tr>
   
<%do while not rs.eof%>

    <tr>
        <td><%=rs("ID")%></td>
        <td align="center">
        <%
        select case rs("ID")
        case 1
         response.write "<font color=yellow>"&rs("UP1")&"</font>"
        case 2
         response.write "<font color=red>"&rs("UP1")&"</font>"
       case 3
         response.write "<font color=purple>"&rs("UP1")&"</font>"
       case 4
        response.write "<font color=green>"&rs("UP1")&"</font>"
        case else
       response.write "<font color=white>"&rs("UP1")&"</font>"
       end select
        %>
          </td>
        <td align="center">
         <%
        select case rs("ID")
        case 1
         response.write "<font color=yellow>"&rs("UP2")&"</font>"
        case 2
         response.write "<font color=red>"&rs("UP2")&"</font>"
       case 3
         response.write "<font color=purple>"&rs("UP2")&"</font>"
       case 4
        response.write "<font color=green>"&rs("UP2")&"</font>"
        case else
       response.write "<font color=white>"&rs("U2")&"</font>"
       end select
        %>
       </td>
    </tr>
</table>
改成这样拿去测试下。

成功了。。再次谢谢gupiao175。