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. -- View this message in context: http://www.nabble.com/--Find-an-empty-cell-in-Data-Range-tf3452240.html#a9646132 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
