Yes, you can just use a simple even macro like

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = 1 Then Range("B1").Value = 5 Else Range("B1").Value =
6
End Sub


right click on the sheet tab in question and paste in the above, press Alt +
Q to close the VB editor
and test it
--

Regards,

Peo Sjoblom

"alMandragor" wrote in message
...
Thank you Peo,

I will try to get some info on VBA (visual basic???)

"Peo Sjoblom" wrote:

No, only through VBA

--

Regards,

Peo Sjoblom


"alMandragor" wrote in message
...
Example:

A Formula in Cell A1 should do the following:

If cell A1 equals 1, then cell B1 should have the value 5, otherwise
B1
should be 6.

A condition in cell A1 is changing the value of cell B1... is that
possible?

Please note that there is NO Formular in Cell B1, which is the cell to
be
modified...

Thanks