m5k1umn 发表于 2024-10-1 18:04:19

怎么样怎么样在表格中自动显著暗示双休日？


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">此刻</span>不少人<span style="color: black;">爱好</span>用Excel来制作备忘录或安排工作事项。在表格中输入日期后，<span style="color: black;">能够</span><span style="color: black;">运用</span><span style="color: black;">要求</span>格式<span style="color: black;">明显</span><span style="color: black;">表示</span>双休日，避免在<span style="color: black;">休憩</span>日安排了工作。<span style="color: black;">详细</span><span style="color: black;">办法</span>是<span style="color: black;">这般</span>的：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1步：<span style="color: black;">选取</span>要设置<span style="color: black;">要求</span>格式的日期单元格区域；在“<span style="color: black;">起始</span>”选项卡的“样式”组中单击“<span style="color: black;">要求</span>格式”按钮；在弹出的下拉列表中单击“新建规则”选项，操作如下图所示。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/200d483317c4426f9f1a30a714b38773~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727979775&amp;x-signature=FHq4i5%2BSdTTD6Olw1Y73%2BXHfsfU%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第2步：弹出“新建格式规则”对话框，在“选中规则类型”列表框中<span style="color: black;">选取</span>“<span style="color: black;">运用</span>公式确定要设置格式的单元格”选项；在“编辑规则说明”栏的文本框中输入公式“=WEEKDAY($A3,2)&gt;5”单击“格式”按钮，操作如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">重视</span>：WEEKDAY(日期,2)：<span style="color: black;">暗示</span>返回数字1（星期一）到数字7（星期日），<span style="color: black;">倘若</span>函数返回的数字&gt;5，即6或7，<span style="color: black;">暗示</span>这个日期为星期六或星期日。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/86958050947c4bf38f7abdf70dcf33f5~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727979775&amp;x-signature=EMBkw9yWo3yW0IymOSLr66qXhtY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第3步：弹出“设置单元格格式”对话框，<span style="color: black;">按照</span>需要设置<span style="color: black;">表示</span>方式，本例中在“填充”选项卡<span style="color: black;">选取</span>“橙色”背景色；单击“确定”按钮，操作如下图所示。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p6-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/7b25af1ec1d9495b88b72ae28e46f174~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727979775&amp;x-signature=alTHwejxqmEct91V2Qu6SWCaaWE%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第4步：返回“新建格式规则”对话框，单击“确定”按钮<span style="color: black;">就可</span>。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fc7ea7a226874c659b69ff40f5fd0dd7~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727979775&amp;x-signature=jg9VLT3HrfrcA%2BHkZLw6566QpDU%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">此时</span>就成功为选中的日期列数据，设置双休日<span style="color: black;">明显</span><span style="color: black;">表示</span>规则，方便<span style="color: black;">咱们</span><span style="color: black;">恰当</span>制作备忘录。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/521ad8ff398140e1b767556fd4f27f18~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727979775&amp;x-signature=uI8znBA1cISlnAgyeMvBfXrv8zY%3D" style="width: 50%; margin-bottom: 20px;"></div>




qzmjef 发表于 2024-10-9 12:58:15

这篇文章真的让我受益匪浅，外链发布感谢分享！

wrjc1hod 发表于 2024-10-21 10:58:10

百度seo优化论坛 http://www.fok120.com/

wrjc1hod 发表于 2024-10-26 22:12:17

谢谢、感谢、感恩、辛苦了、有你真好等。

4lqedz 发表于 2024-11-2 05:23:34

期待与你深入交流，共探知识的无穷魅力。
页: [1]
查看完整版本: 怎么样怎么样在表格中自动显著暗示双休日？