Hello大家好,我是帮帮。今天跟大家分享一下Excel头尾排名多色填充显示。メ大家请看范例图片,我们有这样一表格数据。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FNrWdIdTztOgdcYbhjka0AlFva5U1z%3DeTI2JI9t0PwobCG1555747379303.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ第一步,我们先给业绩排名,输入函数:=RANK(B2,B:B)。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FySsR7FJP4tA9JSKkgNz4JhrYMEQcDriqaZ4j7CC3LPWRs1555747379305.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ选中C2下拉,复制函数。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FOK7TT7sr4wMcuEtJrFTpqPb5iIrpxmAz8Q%3DXa5RXwV7Sv1555747379305.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ第二步,选中C列数据点击条件格式中的【新建规则】。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2Fi4rEj3xxCx9U0Yf1KSLJvLVyG0COHn2t%3DqFsz%3DQ02bCjj1555747379305.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ第三步,选中“仅对排名..”后进行设置。【前1】是指排名数最大即最后一名,打开格式中更改填充为红色。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2F3AOE%3DSG374pZ34KTQckEzDLhkv2luCOZbb3xZQRMsFfp81555747379307.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ第四步,同样的设置【后1】即第一名为某种暖色。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FvxJIACAcrkgchCGoundMb04eJF8EuhKVg%3Dfnd1LSKflWu1555747379307.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
メ最后的结果如下图所示。メ
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FS%3D0mhLa%3DtNgX8wvsn%3Ddfvy3txfVfWmRhrBOi3OoE1c5Z41555747397260.jpg&thumbnail=660x2147483647&quality=80&type=jpg)
![](https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2F2019%2F03%2F31%2F611df9969027404ebcc296ea98eb702f.png&thumbnail=660x2147483647&quality=80&type=jpg)
亲爱的读者们,感谢您花时间阅读本文。如果您对本文有任何疑问或建议,请随时联系我。我非常乐意与您交流。
发表评论:
◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。