Mutually-Exclusive Updating Cells

karsten_patzer

New Member
Joined
Apr 19, 2022
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
Hello,

I'm categorizing a list of cards. I have several columns. In these several different lists, there are cards that are shared and move around from deck to deck.

My categorization system is:
Highlighted Green: In deck, not shared
Highlighted Blue: In deck, shared
Highlighted Orange: Not-in-Deck, shared (other deck is using it).

I want to keep this organized, so that when I want to use one deck, I can look and see where the cards are.

The functionality I want to implement is: When I move shared cards to list #1 from list #2, I want to highlight or otherwise mark list #1 cell so that it turns blue, but will force the corresponding cell in list #2 to turn orange. In this way, only one deck on excel can be marked as having a given type of card, with all other decks forcibly marked "Not in deck, shared".

I've thought through some stuff but I don't know a good way to do this.

Has anyone here thought of a way to implement this functionality?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,214,424
Messages
6,119,401
Members
448,893
Latest member
AtariBaby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top