conditional cell formating

[Guest]

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.

 

[Maistrye]

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 ha
been
closed. Can I format the cells to so that when I have the case marke
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 Dat
Validation list with choices Open and Closed in D1.

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

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

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

Scot

 

[Guest]

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

 

[Guest]

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