本文操作环境为Win10,Excel2013
设置单元格格式
方法一
![img_785b8f90369c2e2540c4a2b788c0a105.png](https://yqfile.alicdn.com/img_785b8f90369c2e2540c4a2b788c0a105.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
方法二:框住想要设置的区域,右键弹出菜单,如下图所示位置。
![img_08aa2ce1147a354d9a5ba32e0d67e231.png](https://yqfile.alicdn.com/img_08aa2ce1147a354d9a5ba32e0d67e231.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
数字可以被设成的格式有12种:常规、数值、货币、会计专用、日期、时间、百分比、分数、科学记数、文本、特殊、自定义
![img_89f420d05a63067b51d5be0b000b2ba1.png](https://yqfile.alicdn.com/img_89f420d05a63067b51d5be0b000b2ba1.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
利用条件格式给单元格上色
科类上色
按照下面图的顺序进行相同的操作可以实现,图片名即为此步作用。
![img_b8df1b7a25659563b00354e88041a1f7.png](https://yqfile.alicdn.com/img_b8df1b7a25659563b00354e88041a1f7.png?x-oss-process=image/resize,w_1400/format,webp)
框住上色区域的单元格.png
![img_3593637c3a354c8c2812225ea82fcad9.png](https://yqfile.alicdn.com/img_3593637c3a354c8c2812225ea82fcad9.png?x-oss-process=image/resize,w_1400/format,webp)
条件格式.png
![img_3e2ca98431ded80e17c01eff31a533c3.png](https://yqfile.alicdn.com/img_3e2ca98431ded80e17c01eff31a533c3.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
![img_1e35290d3fdc2b9e86efb0d25991684b.png](https://yqfile.alicdn.com/img_1e35290d3fdc2b9e86efb0d25991684b.png?x-oss-process=image/resize,w_1400/format,webp)
单元格等于"理工类“则上色.png
![img_bad062983e04d814d1d02e34d76c32a9.png](https://yqfile.alicdn.com/img_bad062983e04d814d1d02e34d76c32a9.png?x-oss-process=image/resize,w_1400/format,webp)
自定义单元格格式.png
![img_4dca101fa20fa4a0cfd3ed0d28ffa7ff.png](https://yqfile.alicdn.com/img_4dca101fa20fa4a0cfd3ed0d28ffa7ff.png?x-oss-process=image/resize,w_1400/format,webp)
设置背景颜色.png
![img_f0b5b233ce1b8d09e282ff909ff7a083.png](https://yqfile.alicdn.com/img_f0b5b233ce1b8d09e282ff909ff7a083.png?x-oss-process=image/resize,w_1400/format,webp)
设置字体颜色.png
![img_f0c45bf2e9b4ba55de3b18db733ff812.png](https://yqfile.alicdn.com/img_f0c45bf2e9b4ba55de3b18db733ff812.png?x-oss-process=image/resize,w_1400/format,webp)
上色成功效果.png
录取分数上色
![img_8ac2af34e855f5490d0b5bee5e52fb99.png](https://yqfile.alicdn.com/img_8ac2af34e855f5490d0b5bee5e52fb99.png?x-oss-process=image/resize,w_1400/format,webp)
框住上色区域和大于规则.png
![img_3d6e8e0056834e6e9f26b2e68dee33d9.png](https://yqfile.alicdn.com/img_3d6e8e0056834e6e9f26b2e68dee33d9.png?x-oss-process=image/resize,w_1400/format,webp)
设置大于600的单元格上色.png
![img_f22bb4a726418c1f699aa490f4103772.png](https://yqfile.alicdn.com/img_f22bb4a726418c1f699aa490f4103772.png?x-oss-process=image/resize,w_1400/format,webp)
录取分数上色结果.png
学费/年 上色
![img_029f3ca60e528f4f54a509959f209c45.png](https://yqfile.alicdn.com/img_029f3ca60e528f4f54a509959f209c45.png?x-oss-process=image/resize,w_1400/format,webp)
image.png
排序
降序排序
![img_c59a65de7f58557345f8e37b88a19104.png](https://yqfile.alicdn.com/img_c59a65de7f58557345f8e37b88a19104.png?x-oss-process=image/resize,w_1400/format,webp)
选定区域和选择排序方法.png
![img_31ddf674c25d8fd0a9f045b9b4ee25e1.png](https://yqfile.alicdn.com/img_31ddf674c25d8fd0a9f045b9b4ee25e1.png?x-oss-process=image/resize,w_1400/format,webp)
默认扩展当前区域.png
上图点击 排序后效果图如下。
![img_ef314586397c1d94890c7956f02bc01e.png](https://yqfile.alicdn.com/img_ef314586397c1d94890c7956f02bc01e.png?x-oss-process=image/resize,w_1400/format,webp)
降序排序效果图.png
筛选
筛选出学费大于10000元,同时录取分数大于600分的表格
![img_44b5ec05e1aadffe113a57d991998157.png](https://yqfile.alicdn.com/img_44b5ec05e1aadffe113a57d991998157.png?x-oss-process=image/resize,w_1400/format,webp)
手动输入条件表格.png
![img_7bdcc7413ea099df4086b7c7620d3685.png](https://yqfile.alicdn.com/img_7bdcc7413ea099df4086b7c7620d3685.png?x-oss-process=image/resize,w_1400/format,webp)
高级筛选.png
![img_0114eb8e97166bdae015bb495b909f17.png](https://yqfile.alicdn.com/img_0114eb8e97166bdae015bb495b909f17.png?x-oss-process=image/resize,w_1400/format,webp)
将筛选结果复制到其他位置.png
列表区域选择
![img_5fba4cf37e321b73f14d79fb892f2f1e.png](https://yqfile.alicdn.com/img_5fba4cf37e321b73f14d79fb892f2f1e.png?x-oss-process=image/resize,w_1400/format,webp)
列表区域.png
条件区域选择
![img_3dfe7fcb35e579bc53cc1af2c985bfd2.png](https://yqfile.alicdn.com/img_3dfe7fcb35e579bc53cc1af2c985bfd2.png?x-oss-process=image/resize,w_1400/format,webp)
条件区域.png
复制到选择
![img_bde0f8194802bdd9ce4b4a59335b64ff.png](https://yqfile.alicdn.com/img_bde0f8194802bdd9ce4b4a59335b64ff.png?x-oss-process=image/resize,w_1400/format,webp)
选择>10000下面一个格子.png
![img_4c259c7060d849956a7d22d3b942a58b.png](https://yqfile.alicdn.com/img_4c259c7060d849956a7d22d3b942a58b.png?x-oss-process=image/resize,w_1400/format,webp)
筛选结果图示.png
筛选出学费大于10000元,或者录取分数大于600分的表格信息
![img_7facee71bdfd781bbb79f3db219818dd.png](https://yqfile.alicdn.com/img_7facee71bdfd781bbb79f3db219818dd.png?x-oss-process=image/resize,w_1400/format,webp)
将两个条件写在不同行.png
![img_7a419f42b76fc5a0fd0ac11af7e203cb.png](https://yqfile.alicdn.com/img_7a419f42b76fc5a0fd0ac11af7e203cb.png?x-oss-process=image/resize,w_1400/format,webp)
筛选结果图示2.png
数据验证
![img_b39e9e09bc92fda6206f8b9ebcd3b649.png](https://yqfile.alicdn.com/img_b39e9e09bc92fda6206f8b9ebcd3b649.png?x-oss-process=image/resize,w_1400/format,webp)
手动输入两个科类.png
![img_a195a7a87e4f6f724d97e7c8af747c0c.png](https://yqfile.alicdn.com/img_a195a7a87e4f6f724d97e7c8af747c0c.png?x-oss-process=image/resize,w_1400/format,webp)
数据验证位置.png
![img_dc84b88611d352a53ff83769a7e61c73.png](https://yqfile.alicdn.com/img_dc84b88611d352a53ff83769a7e61c73.png?x-oss-process=image/resize,w_1400/format,webp)
数据验证设置.png
![img_3d70540652d0aefc6843855e6ad8c43d.png](https://yqfile.alicdn.com/img_3d70540652d0aefc6843855e6ad8c43d.png?x-oss-process=image/resize,w_1400/format,webp)
设置成功图示.png
![img_56d8530bf0e34db7a8b7c48ba0c66803.png](https://yqfile.alicdn.com/img_56d8530bf0e34db7a8b7c48ba0c66803.png?x-oss-process=image/resize,w_1400/format,webp)
圈释无效数据位置.png
![img_58ba02495b603f4a3840a1771bdb7bff.png](https://yqfile.alicdn.com/img_58ba02495b603f4a3840a1771bdb7bff.png?x-oss-process=image/resize,w_1400/format,webp)
圈释后效果.png
保护单元格
![img_a8d47fac0109080765023f636eed34ea.png](https://yqfile.alicdn.com/img_a8d47fac0109080765023f636eed34ea.png?x-oss-process=image/resize,w_1400/format,webp)
全选并且取消锁定.png
![img_a47a240000bb3ed05401579622c181c3.png](https://yqfile.alicdn.com/img_a47a240000bb3ed05401579622c181c3.png?x-oss-process=image/resize,w_1400/format,webp)
选定要保护的区域并设为锁定.png
![img_a5f7ddd617a68832437633ceb83c67ce.png](https://yqfile.alicdn.com/img_a5f7ddd617a68832437633ceb83c67ce.png?x-oss-process=image/resize,w_1400/format,webp)
保护工作表位置.png
![img_d96eeb1be353818d9e8e3e8d3195d46d.png](https://yqfile.alicdn.com/img_d96eeb1be353818d9e8e3e8d3195d46d.png?x-oss-process=image/resize,w_1400/format,webp)
设置密码.png
保护单元格就上面四步