|You didn't say what version of Excel you are using, but Conditional Formatting is what you are looking for.|
In 2003 it's:
1 - Select C7
2 - Format...Conditional Formatting
3 - Condition 1 Drop Down: Choose "Formula Is:"
4 - Click Format and choose a Pattern color
5 - OK your way out.