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.