条件格式(如果不为空) [英] Conditional Formatting (IF not empty)
问题描述
如何有条件地格式化单元格,如果不是空白的,它是灰色的?
我试图做不相等,但没有起作用。
我正在使用Windows Office 2003与Windows XP在工作。我看不到与以下相同的功能:
目前为止我已尝试过:
编辑:图出了什么问题。在我的生产(实际工作Excel)中,他们充满了白色。这不是我的Excel文件,所以我以前没有意识到这一点。
您可以使用带有选项的条件格式公式是。一个可能的公式是
= NOT(ISBLANK($ B1))
pre>
另一个可能的公式是
= $ B1<>
How do I conditionally format a cell so if not blank it is grey?
I tried to do 'not equal', but it didn't work.
I am using Windows Office 2003 with Windows XP at work. I don't see the same feature as below:
What I have tried so far:
Edit: Figured what was wrong. In my production (actual work Excel), they were filled with white color. It wasn't my Excel file, so I was not aware of this before.
解决方案You can use Conditional formatting with the option "Formula Is". One possible formula is
=NOT(ISBLANK($B1))
Another possible formula is
=$B1<>""
这篇关于条件格式(如果不为空)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!