|Are you familiar with the Conditional Formatting feature? If not, look it up in the Excel help files or do a Google search.|
CF is set up differently depending on which version of Excel you are using.
The CF feature has a wizard that allows you to enter formulas that will return either TRUE or FALSE. When the formula returns TRUE, the formatting that you chose via the wizard is applied.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.