It seems to be hit and miss that I get this #NAME? error in the same field. It does not seem to matter what the data is in that spot it still makes the error during PRINT PREVIEW or PDF EXPORT. I've also tried removing the conditional formatting and that has not made a differance, It is supposed to say BLU. I have tried changing the sort on put the GREEN on top and it still gives the same error. Like I said, some reports it is fine but others give me this. Any idea's?