Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I test if a cell is empty?
I have a web programme (over which I have no control) which outputs data to
an excel spreadsheet. Some cells appear empty and I want to highlight them using conditional formatting. However, when I use the ISBLANK function, it transpires that the apparently empty cells do have something in them, even though I cannot identify what it is. The cells appear blank when you select each cell - however, when I press delete and enter, something is clearly being removed as the conditional formatting then shows the cells as empty. I hope this makes sense. Has anyone else every encountered this situation please? Is there a way of getting round this either by using a function which will clear the apparently empty cells, or another function I can use with conditional formatting to identify the so called empty cells. Thanks, V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
test expression for empty cell in =SUMIF() | Excel Worksheet Functions | |||
Test if the range is empty | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) |