excel打开提示standard.css文件丢失

html-css09

excel打开提示standard.css文件丢失,第1张

你的EXCEL文件应该是从网页上导出或者下载来的。把这个EXCEL文件扩展名改成HTML，用浏览器打开，应该可以打开并显示正常了。CTRL+A,CTRL+C将数据复制出来，粘贴到你其他正常的EXCEL文件里面去。OK，搞定！

要使用条件格式的公式， 需要把两个sheet表的数据放到一个sheet表中，然后设置B1 的公式

=(B1=VLOOKUP($A1,$O:$S,MATCH(B$1,$O$1:$T$1,0),0))

先设置B1，然后用格式刷到其他列

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns=" http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/htmlcharset=gb2312" />

<title>无标题文档</title>

<style type="text/css">

input{ border:0px}

.ov{ border:2px solid #009999}

.input{ border:0px}

</style>

</head><body>

<form id="form1" name="form1" method="post" action="">

<table width="366" border="0" cellspacing="1" bordercolor="#333333" bgcolor="#333333">

<tr>

<td width="17" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"></td>

<td width="168" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>A</label></td>

<td width="204" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>B</label></td>

</tr>

<tr>

<td width="17" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'">1</td>

<td width="168" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield" />

</label></td>

<td width="204" bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield2" />

</label></td>

</tr>

<tr>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'">2</td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield3" />

</label></td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield4" />

</label></td>

</tr>

<tr>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'">3</td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield5" />

</label></td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield6" />

</label></td>

</tr>

<tr>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'">4</td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield7" />

</label></td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield8" />

</label></td>

</tr>

<tr>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'">5</td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield9" />

</label></td>

<td bgcolor="#FFFFFF" onmousedown="this.className='ov'" onmouseout="this.className='input'"><label>

<input type="text" name="textfield10" />

</label></td>

</tr>

</table>

</form>

</body>

</html>

做了一个，功能差不多的。