=if(iserror(myformula,"",myformula)

:)
Put YOUR formula where it says myformula.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"cac1966" wrote in message
...
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.