Thanks for suggestion,... Thanks a ton
now i can find an empty cell in my data ranges easier....
TerryJ Menulis:
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.
The information transmitted is intended only for the person or the entity to
which it is addressed and may contain confidential and/or privileged material.
If you have received it by mistake please notify the sender by return e-mail
and delete this message including any of its attachments from your system. Any
use, review, reliance or dissemination of this message in whole or in part is
strictly prohibited. Please note that e-mails are susceptible to change. The
views expressed herein do not necessarily represent those of PT Astra
International Tbk and should not be construed as the views, offers or
acceptances of PT Astra International Tbk.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
