3

excel 里,如何设置输入数字 1 整行变绿、输入数字 2 整行变黄、输入数字 3 整行变红

 2 years ago
source link: https://www.v2ex.com/t/868189
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

V2EX  ›  问与答

excel 里,如何设置输入数字 1 整行变绿、输入数字 2 整行变黄、输入数字 3 整行变红

  ZC3746 · 31 分钟前 · 67 次点击
条件格式里输入=$D1="完成"、设置格式为绿色,可以整行变绿,但不知道为什么=$D1="1"就不行。

求指点。谢谢!

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK