|Conditional Formatting should be able to do what you are asking for, but without some more detailed information, we can't offer any specific suggestions.|
re: "compare them with the information in another sheet "
Please tell us what you mean by that. Are you comparing columns to columns, a column to a row, something else?
If you need to post some example data to make this clearer, please click on the following sentence and read the instructions for posting data in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.