精英试题第二题更改要求，怎么做？

hccj2008

1段试题第二题 <table cellspacing="0" cellpadding="0" width="381" border="0" style="WIDTH: 286pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col span="3" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl63" width="237" colspan="3" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 178pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ccffff; mso-ignore: colspan;"><font face="MingLiU" color="#ff0000">1. 凡购书数量超过 500 打八折</font></td><td class="xl63" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ccffff;"><font face="MingLiU" color="#ff0000">　</font></td><td class="xl63" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ccffff;"><font face="MingLiU" color="#ff0000">　</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl63" colspan="5" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ccffff; mso-ignore: colspan;"><font face="MingLiU" color="#ff0000">2. 在「说明」栏填入「打八折」或「不打折」</font></td></tr></tbody></table><p>改为</p><p><table cellspacing="0" cellpadding="0" width="381" border="0" style="WIDTH: 286pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col span="3" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl65" width="237" colspan="3" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 178pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ccffff; mso-ignore: colspan;"><font face="MingLiU" color="#ff0000">1. 凡购书数量超过 500 打八折</font></td><td class="xl65" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ccffff;"><font face="MingLiU" color="#ff0000">　</font></td><td class="xl65" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ccffff;"><font face="MingLiU" color="#ff0000">　</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl65" colspan="5" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.5pt; BACKGROUND-COLOR: #ccffff; mso-ignore: colspan;"><font face="MingLiU" color="#ff0000">2. 在「说明」栏填入「打八折」（底框颜色变为红色）或「不打折」（底框颜色为绿色）。</font></td></tr></tbody></table></p>

detifo

什么意思？

折扇轻摇

<p>用条件格式啊[em01]</p><p>如：格式---条件格式里输入公式</p><p>然后选显示效果。OK？</p><p>IF（A1&gt;500,"打八折","不打折")</p><p>&nbsp;</p>[em01]

hccj2008

就是在显示“打八折”的同时能让底色变为红色，显示“不打折”时底色改为绿色。。。不是用选显示效果

pigpet

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>hccj2008</i>在2007-5-21 16:43:18的发言：</b><br/>就是在显示“打八折”的同时能让底色变为红色，显示“不打折”时底色改为绿色。。。不是用选显示效果</div><p></p>我觉得条件格式应该可以实现你的要求啊，一旦文字条件等于打八折，底色对应成为红色，同理不打折的文字出现时。

hhzjxss

请勿在论坛讨论试题！