Sure, take a look at Conditional Formatting in XL Help.

One way:

C1: =B1 - A1

Select C1. Choose Format/Conditional Formatting...

CF1: Formula Is =(B1/A1-1)10%
Format1: Pattern/Red


In article ,
"Chandni" wrote:

Is the following possible - the cell showsthe difference in numerical terms
but I also add in a formula that says that if the difference is more than
10%, then the cell is colored red.

Basically, I want to see the difference in numerical terms but would like to
get some indication where the percentage difference is more than 10%.