Conditional Formatting (IF not empty)

Question

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.

Answer 1

Does this work for you:

You find this dialog on the Home ribbon, under the Styles group, the Conditional Formatting menu, New rule....

Answer 2

You can use Conditional formatting with the option "Formula Is". One possible formula is

=NOT(ISBLANK($B1))

Another possible formula is

=$B1<>""