问题已解决
如果達(dá)成率小于80%自動(dòng)標(biāo)紅怎么弄
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
你好,可以使用條件格式,在任務(wù)欄右邊有個(gè)條件格式,選擇突出顯示單元格格式,輸入小于80%,顏色標(biāo)紅即可
2021 10/06 09:40
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 09:41
以后都不用去設(shè)置了,一勞永逸嗎
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
夏天老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/06 09:42
是的,你設(shè)置一次之后以后就不需要設(shè)置,會(huì)自動(dòng)調(diào)的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 09:48
不行,所以太難看了,這一列都是紅色,我這邊表格需要復(fù)制黏貼,添加行的
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 09:48
給別人看到
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
夏天老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/06 09:49
你可設(shè)置大于0小于80,這樣就不會(huì)空格也是紅色了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 09:54
老師然后再設(shè)置一個(gè)屏蔽錯(cuò)誤值的函數(shù)嗎?
FAILED
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
夏天老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/06 09:56
不需要啊,你這個(gè)錯(cuò)誤值是因?yàn)槟闱懊鏇](méi)數(shù)字導(dǎo)致的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 09:57
老師,這么說(shuō)吧,我需要在單元格自定義里面設(shè)置一下
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
夏天老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/06 09:59
我不明白你的意思
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784985 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 10/06 10:08
這邊80%也自動(dòng)標(biāo)紅了喲
FAILED
![](https://pic1.acc5.cn/009/96/08/56_avatar_middle.jpg?t=1651203464)
夏天老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 10/06 10:10
看一下設(shè)置那里是不是小于等于了,我看其他的沒(méi)問(wèn)題
![](/wenda/img/newWd/sysp_btn_eye.png)