Conditional Format

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

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?
 
J

JulieD

Hi

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

Cheers
JulieD
 
C

Continental Translations

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

Thanks Julie
 
Top