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
Please reply *only* to [email protected]
