Conditional Formatting Problem

H

henry

Dear All,

Another thing I need help with is conditional formatting. I have
table and I was wanting to set the conditional formatting so that whil
cells are blank they are hatched out (ie cell pattern applied) but onc
I enter data into the cell then the pattern is removed. I'm no
experienced at writing formulae and can't work out how to appl
formatting to blank cells only

Any help appreciated

Cheers
Henr
 
D

Debra Dalgleish

Select the cells, and choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell,
whose address appears in the name box, to the left of the formula bar:

=A2=""

Click the Format button, and on the Patterns tab, select the pattern
you want for blank cells.
Click OK twice.
 
Top