put a formula into the cell adjacent:

=IF(A1="","",10)

David Miller


Dave wrote:
How do I get an opposite cell to display the value 10 if the adjacent
cell contains a value just entered?

example:

a b
4 10
5 10
8 10
2 10