Select cell A3 that contains the number 4 and select the menu option Format |
Conditional Fomating

in the popup form Conditional Formatting set the Condition 1 settings as
follows

Cell Value Is equal to =$A$2+1

Click on the Format button and format the text if the result is True e.g.
back ground color is Dark Red, font color is white and bold.

hope that helps

" wrote:

value in cell in one digit more than cell above. Is this possible?

ex:

A
1
3
4
7

4 would be highlighted.