The conditional formatting feature in Excel is so cool!
If you use FALSE and TRUE expressions to check validity, you can easily make these red and green.
[Wayback/Archive] Conditional formatting of TRUE / FALSE values in an Excel 2010 range – Super User (thanks [Wayback/Archive] tbone for asking and [Wayback/Archive] digitxp for answering):