Wow, I just be brain dead. In Excel 2003, I could choose individual
conditional formatting for one cell. In Excel 2007, it seems I have to choose
rules for the entire sheet....I don't want to do that. I just want to apply
a conditional format to one individual cell. How can I accomplish that?

--
Thank you all for your help!