Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF! trying to white out
I have copied a formula on a ledger for Purchase Orders. As I place an order
into a worksheet the information automatically fills on the ledger (separate sheet). The cells for which there has not been a purchase order entered yet I am getting a #REF! error. Basically I have a sheet full of these. I tried to do conditional formatting to white out this error but not luck. I am wanting nothing to show in the unused blanks until a PO has been entered. Any help with this would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting this white line? | Excel Discussion (Misc queries) | |||
EXCEL workbook is off-white, goes white in edit mode | Excel Discussion (Misc queries) | |||
What does it mean when my cursor looks like a white cross or plus | Excel Discussion (Misc queries) | |||
White Space in a Cell | New Users to Excel | |||
White Space in PDF from Excel | Excel Discussion (Misc queries) |