折柳成萌
高粉答主
2022-11-05
·
繁杂信息太多,你要学会辨别
知道顶级答主
回答量:4.4万
采纳率:96%
帮助的人:5375万
关注
初始化表格,A列为固定序列的条件列,B列根据A列的值显示对应的字体、底纹等格式。
![](https://iknow-pic.cdn.bcebos.com/c8ea15ce36d3d539285b90522887e950352ab039?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
设置A2为序列,选项有“是”和“否”。
![](https://iknow-pic.cdn.bcebos.com/b7003af33a87e95097716cfd02385343fbf2b439?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
设置B2为条件格式,点击开始菜单。
![](https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600a5a89026fb50352ac65cb739?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
当A2为"是"时,B2的底纹为红色,当A2为"否"时,B2的底纹为绿色,选中单元格B2,打开条件格式进行设置。
![](https://iknow-pic.cdn.bcebos.com/37d3d539b6003af39adc43f1272ac65c1038b639?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
最后将A2和B2的格式下拉到需要的单元格,选择A列单元为”是“时,对应B列单元格显示红色,选择A列单元为”否“时,对应B列单元格显示绿色,就完成了。
![](https://iknow-pic.cdn.bcebos.com/3bf33a87e950352a6507ba994143fbf2b2118b39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
收起
为你推荐: