| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
set cell to empty
GOT IT! Instead of doing a conditional format on "cell = blank" I tested for
"cell has error" and the white font cleaned up the #N/A error messages. And the blank data points did not plot in the graphs. It would be cool if I could only get the labels on the horizontal axis to only show the non-blank rows (as when it's filtered) but will do. I can FInally get to my other projects. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | 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) | |||
Threaded Mode
