EXCEL 2007
You appear to want Conditional Formatting.
You may find the following helpful.
Go into F 1 Help Facility and type in:-
conditional formatting
Hit the Search, "button".
There is s topic called:-
Conditionally formatted data: Examples and guidlines
Click on the above topic.
Opening the above topic there is a hyperlink about three quarters of the way
down the page called:-
Conditional Formatting Samples
Click on the above hyperlink.
A file will open that provides many examples of what you might need.
If my comments have helped please hit Yes.
Thanks.