I have a spreadsheet with 2 worksheets. (See Attachment)
On one I have an alphabetical listing off all available pokemon. On the other I have a Pokemon Evolution Chart.
On the alphabetical listing I mark pokemon I already have with a background/fill color.(magenta in this case) & so I am able to keep track which ones I already have.
Would there be a way of giving the pokemon in the Evolution Chart the same color as they have in the alphabetical listing?
Because manually changing that is a time consuming thing… And i’d rather spend that time catching them than keeping track of them…
Thanks for the help…
Cheers
Zotteken
EDit by mark_t:-
Updated your document to use conditional formatting based on an additional column named “Got It”. I found it easier to modify your data format, to make conditional formatting formula simpler. As its based on @Lupp’s suggestion I added to your question instead of adding my own answer.
pokemon.ods