cell value depends on value in another cell question

Hi. Anyone know how to have a cell formula control the information in another cell? I'm trying to get a row of cells to only allow one x (trying to get them to act like a check box that only allows one check). I can't figure if excel is capable of controling a cell's value from an outside formula.

Hi
maybe 'Data - Validation' is what you're looking for. See
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


Sylvia wrote:
Hi. Anyone know how to have a cell formula control the information
in another cell? I'm trying to get a row of cells to only allow one
x (trying to get them to act like a check box that only allows one
check). I can't figure if excel is capable of controling a cell's
value from an outside formula.

Maybe.......... =IF(A1=1,"X","")

Vaya con Dios,
Chuck, CABGx3



"Sylvia" wrote in message
...
Hi. Anyone know how to have a cell formula control the information in
another cell? I'm trying to get a row of cells to only allow one x (trying
to get them to act like a check box that only allows one check). I can't
figure if excel is capable of controling a cell's value from an outside
formula.