see attached example
conditional format is finicky and hard to teach in words and example as the steps to setup along the way matter
maybe this can help?
http://office.microsoft.com/en-au/ex...in=HA010370614
if not there are plenty of youtube examples
ps the version of excel you are using matters
Bookmarks