kthornton Wrote:
I have a spreadsheet to track RMA cases. I have one cell when marked
indicates the case is open. The other cell indicates the case has
been
closed. Can I format the cells to so that when I have the case marked
as open
the the closed cell will be blank and vice versa?

A1 B1 C1
Company Name Open Closed

Joe company x


When B1 is marked with an "X" C1 should be blank and vice versa.

To do exactly what you're saying will probably require a macro.

Could you do something slightly different?

Perhaps put in an extra column (I'll say Column D) with a Data
Validation list with choices Open and Closed in D1.

Then, in B1 put the formula =IF(D1="Open","X","") and in C1 the formula
=IF(D1="Closed","X","").

That way, you can toggle back and forth without writing a macro and
have the X's pop into the cell.

Alternatively, don't worry about the X's and just have the Data
Validation list only.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=562985