I needed to slow down and read this thing from the beginning. In your first message you instruct me that all we needed was the conditional formatting. I had added your latest addition for the empty "Find" correctly but I had forgotten to change the conditional format formula. I couldn't figure out why we needed the formula twice and that's when I remembered all we needed was the conditional formatting. Thank you so much for all your help and patience here. This is a real timesaver for me.