Menu
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.
367
If I highlight Cells A1-G10, then use the conditional formatting statement above, =NOT(ISBLANK(A1)), and select a colr for fill, what I would 'expect to happen' is if A1 is blank, no cells would be filled. If A1 has a non-blank value, ALL the cells from A1 through G10 would be highlighted, since A1 is no longer blank.
The easiest way to highlight rows with non-blank cells is using Format only cells that contain rule from the New Formatting Rule window of Conditional Formatting. First, select your dataset and go to Home > Conditional Formatting > New Rule. Now, the New Formatting Rule window will be opened.
Does this work for you:
You find this dialog on the Home ribbon, under the Styles group, the Conditional Formatting menu, New rule....
56
You can use Conditional formatting with the option "Formula Is". One possible formula is
=NOT(ISBLANK($B1))
Another possible formula is
=$B1<>""
19
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
