TerryJ wrote:
Harold Fuchs-2 wrote:
TerryJ wrote:
Ahromi Irawan, Cirebon wrote:
OOo 2.1 Calc; WinXP
Dear All,
how i can find an empty cell in a data range, if I use filter it will
removing the data structure.
what the RegEx syntax's that find an empty cell ?
--
Ahromi, Indonesia
I Can't speak english well
If there is no regular expression (which I believe to be the case), you
could use formulas to search each column and row.
For example, suppose your data range is A1:J100 . I A102, insert the
formula =ROWS(A1:A100)-COUNTA(A1:100) . Drag the formula to column J -
that
will tell you the number of blank cells in each column. In L1, the
formula
=COLUMNS(A1:A100)-COUNTA(A1:100) will tell you the number of blank cells
in
row 1 and you can drag it down to row 100.
First, define a new style based on the Default. The only thing this new
style has is a blue background.
Now select the range of cells you want to search and use Conditional
Formatting (Format>Conditional Formatting) to format the cells with the
style you just created *if* the "cell value" is "equal to" <null> where
"<null>" means you don't enter anything in the box.
This will find empty cells, within the selection, and highlight them in
blue.
Unfortunately it will also find cells where the value is zero but
perhaps you can live with that ...
--
Harold Fuchs
London, England
That's a good idea. But it can be altered to find ONLY blank cells.
Instead of using cell value use "Formula is" and insert ISBLANK(A1) - using
the correct cell address of course. You can select your data range, note
the cell where the cell pointer is located (that is the cell address to
insert) and apply conditional formatting for the whole range. As long as
you insert a relative cell address, the cell address will change for each
cell in the range.
Very pretty! Thanks.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
