Highlight if ...

[calibansfolly]

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

ex:

A
1
3
4
7

4 would be highlighted.

 

[David Biddulph]

Format/ Conditional formatting

If your active cell is A3, then either:
Cell value is/ equal to: =A2+1 or
Formula is: =A3=A2+1

 

[Pete_UK]

Highlight the cells from the second one onwards - i.e. from A2 in your
example. Click Format | Conditional Format and in the pop-up select
Formula Is rather than Cell Contents and in the next panel enter this
formula:

A2=A1+1

Click the Format button on the panel, click patterns (background
colour) and choose your highlight colour, eg Bright Yellow. Then click
OK twice and you should see the number 4 highlighted with bright
yellow.

Hope this helps.

Pete

 

[Guest]

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