Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

如何根据一列中的数值等于某个值来设置整行的背景色 #41

Open
jojo-d opened this issue Sep 29, 2018 · 2 comments
Open

如何根据一列中的数值等于某个值来设置整行的背景色 #41

jojo-d opened this issue Sep 29, 2018 · 2 comments

Comments

@jojo-d
Copy link

jojo-d commented Sep 29, 2018

如何根据一列中的数值等于某个值来设置整行的背景色？
是否有if语句来确定当前行要不要生成的方法？
@jojo-d
Copy link
Author

jojo-d commented Sep 29, 2018

从ejsExcel的角度暂时没找到方案，采用excel的条件格式配置来实现了，但不好的地方是需要添加一列来存取公式判断需要用到的数据，即使隐藏列，也会显得有所赘余。
期待有更好的方案一起分享。

@sail-sail
Copy link
Owner

目前的话, 比较多的是用 条件格式, 或者 VBA 去实现
<%ifRBegin ...%>配合<%ifREnd%> 应该也可以

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@sail-sail @jojo-d