#REF! trying to white out
Trap your error by adjusting your formula; for example:
=IF(ISERROR(A1+B1),"",A1+B1)
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"cac1966" wrote:
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.
|