Hello 
open new spreadsheet
put in cell A1 a value, [100]
press CTRL F3
make a name for cell A1, [ape]
select an other cell (B1)
go to conditional format dialogue box true menu ....format? (in Dutch it is menu
opmaak)
first list-box select formula
second box (condition box) write [ape = 100]
ad new format that makes the background red, and give this format a name [red]
choose this name in the list box

When you change the value of cell A1 from 100 to something else and back again
cell B1 will turn on and of with the colour red. This is good and big fun.

When you move cell A1 with CTRL x and CTRL V everything looks al right but will
not work until you make a little change in the conditional format dialogue box.
for instance get rid of a space [ape= 100] . now it will work again. If you use
a other way to move cell A1 you get the same bad result.

This is my first input in OOo I hope it is clear 
regards Verhallen