Conditional Format

This question has probably been asked a thousand times but just scrolled
through and couldn't find it.

I want to conditional format my sheet, so if there is an empty cell
containing no information or data, then I would like that cell to change
colour. I know to use conditional format and use a formula, but what
formula?

Hi

in conditional formatting use
Value is
equal to
=""
and set the patterns tab to whatever you want.

Cheers
JulieD


"Continental Translations" wrote in message
...
This question has probably been asked a thousand times but just scrolled
through and couldn't find it.

I want to conditional format my sheet, so if there is an empty cell
containing no information or data, then I would like that cell to change
colour. I know to use conditional format and use a formula, but what
formula?

I knew it was something like that. I tried =IF"" but had no jou!

Thanks Julie

JulieD wrote in message
...
Hi

in conditional formatting use
Value is
equal to
=""
and set the patterns tab to whatever you want.

Cheers
JulieD


"Continental Translations" wrote in
message
...
This question has probably been asked a thousand times but just scrolled
through and couldn't find it.

I want to conditional format my sheet, so if there is an empty cell
containing no information or data, then I would like that cell to change
colour. I know to use conditional format and use a formula, but what
formula?