Conditional Formatting Problem

[henry]

Dear All,

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

Any help appreciated

Cheers
Henry

[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.


henry wrote:
> Dear All,
>
> Another thing I need help with is conditional formatting. I have a
> table and I was wanting to set the conditional formatting so that while
> cells are blank they are hatched out (ie cell pattern applied) but once
> I enter data into the cell then the pattern is removed. I'm not
> experienced at writing formulae and can't work out how to apply
> formatting to blank cells only
>
> Any help appreciated
>
> Cheers
> Henry
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[henry]

Thankyou.... so easy when you know how.