C
calibansfolly
value in cell in one digit more than cell above. Is this possible?
ex:
A
1
3
4
7
4 would be highlighted.
ex:
A
1
3
4
7
4 would be highlighted.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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
If your active cell is A3, then either:
Cell value is/ equal to: =A2+1 or
Formula is: =A3=A2+1
P
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
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
K
Kevin McCartney
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
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