conditional formatting... I am trying to understand HOW to use this. If I knew more I am sure it would make sense however I can't see in the information exactly what steps to take. Do I need to import ALL of the modules? Then copy the VBA to my form. I don't understand about the txt box does it need to be visible. I tried changing the name to my field names but that doesn't work. Sorry, I am a bit confused. Is there a step by step info on how to implement somewhere. By the way I posted 3 other questions "Report Filters by Checked Box" "Lockbox works BUT..." "Scrollbar Problem" and never received any answers if anyone has the time to look at them. (Have also posted questions that have been answered quickly and concisely and I am truly appreciative!!) Thanks!!