Access allows you to conduct conditional formatting on a report, or form field. The unfortunate part is that they only allow 3 conditional formats. I am unfortunatly not a programmer, and wondered if anyone could provide me with a simple code to add as many conditional formats. I am only looking to change the "Back Color". For instantce; If the filed says "RED" I would like the back color to be RED, and so on. I need to be able to add as many colors as I want. Can anyone help?