Advanced Conditinal Formatting

jhren, OP's profile suggests 2003, Im not sure 2003 has that option, and they might not be able to open that file.

@ Gaiden, you may not get too many offers of help with a comment like...

PS. if you are going to ask for a sample workbook then just copy this into a new workbook

1 of the reasons we ask for a sample workbook (apart from you helping us to help you), is so that we can see what excel version you are using, and tailor suggestions accordingly. I know your profile says 2003, but some members forget to update their profile