I have a question about conditional formatting. I am a civil engineer, I use excel to go through each lot to see what house plans work and dont work. I want to color code my different codes that I use to make it easier to see what works and doesnt work. The problem I am running in to is that I can only formatt 3 codes per cell. I need to be able to formatt 10 or so different codes, but I am only using 2 colors. Ex. "LT" is Blue, "NA", "NW" and a couple more codes in Red. Anyone have any idea how to do this?