英文:
Conditional Formatting with a formula at Excel doesn't work
问题
我想按目标日期给线条上色。
我创建了这样的表格
并设置了格式规则
如果日期是“2023/02/21”，那一行的背景色应该更改为“粉红色”...
然而，它不起作用。
你能帮我吗？
我的期望是像这样改变背景颜色
英文:
I want to color the line by target date.
I made table like this
and set formatting rule as
if date is "2023/02/21", the background at that line should be changed to "pink"...
However, it doesn't work.
could you help me?
My expectation is changing background color like this
答案1
得分: 1
它确实有效，因为"21/2/2023"表示的是文本而不是数字，你需要使用如下的代码：
=$C4="21/2/2023"*1
以获取目标日期为21/2/2023的高亮行，确保在你的示例中使用绝对相对引用，如$C4。
请参考屏幕截图中的应用范围：
英文:
It does work, since "21/2/2023" represents a text and not a number, you need to use something as follows
=$C4="21/2/2023"*1
to get the row highlighted where the target dates is 21/2/2023, make it absolute relative reference as $C4 in your example .
Refer the applies to in screen-prints
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论