Thanks for both of your help. I went with the one that left the field blank, but I'm sure I'll be using the conditional formatting in the near future.

Thanks again!!