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.

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

To be honest, I couldn't really see the need for the vice versa thing. If
you indicate that the case is open by placing an "X" in a cell then,
presumably, you would remove the "X" when the case was closed. You could
conditionally format the adjacent cell in a way that you desire, or, you
could enter an IF statement which changes depending on whether the case is
shown as open

i.e. =IF(B1="X","Open","Closed")

Perhaps I'm missing the point ...

"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.

I agree with the conditional formatting OR the "IF" statement. I've used both.

"bigwheel" wrote:

To be honest, I couldn't really see the need for the vice versa thing. If
you indicate that the case is open by placing an "X" in a cell then,
presumably, you would remove the "X" when the case was closed. You could
conditionally format the adjacent cell in a way that you desire, or, you
could enter an IF statement which changes depending on whether the case is
shown as open

i.e. =IF(B1="X","Open","Closed")

Perhaps I'm missing the point ...

"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.