Formulas return values to the cell that they are in. The do not modify other
cells nor do they change formatting (conditional formatting is based on the
result of a formula, and is not the return value of a formula).

Your only hope is to place a formula in the other cell that links back to
the original cell. If that is not an option then you need to consider using
macros which can react to a cell changing value and update another cell
accordingly.
--
HTH...

Jim Thomlinson


" wrote:

From one cells formula I would like to assign values to another
cell.
So if within Cell A1 I have a condition that is true I would like to
assign either a number or string to cell A2.

Thanks,




Rob