Fai la tua domanda

zotteken's profile - attività

2020-07-09 16:06:07 +0200 received badge  Domande famose (source)
2016-09-30 07:26:47 +0200 received badge  Sostenitore (source)
2016-09-30 07:26:43 +0200 received badge  Studioso (source)
2016-09-24 21:38:23 +0200 received badge  Buona domanda (source)
2016-09-24 18:44:06 +0200 received badge  Domanda notevole (source)
2016-09-24 13:31:28 +0200 ha commentato una risposta Background color based on the background color of another cell?

OK, edited the question. As you'll see if you open the files, I have put the evolution chart on the same worksheet as the alphabetical order. I also put the references of the related cells next to the alphabetical column.

2016-09-24 13:29:06 +0200 received badge  Revisore (source)
2016-09-24 12:55:34 +0200 ha commentato una risposta Background color based on the background color of another cell?

Yeah, I assume that's handier than me trying to explain how it looks like... But if karma is required I'll gladly do what's needed to reach the required karma. By looking at your example file I see some things in mine that I'll have to resolve first, I guess, before the conditional formatting is attempted at all. Like the alphabetical listing has just the pokemon name in it, where the corresponding cell in the evolution chart also contains a number in front (I copied it like that of internet)

2016-09-24 12:03:06 +0200 received badge  Studente (source)
2016-09-21 01:07:27 +0200 received badge  Entusiasta
2016-09-18 07:39:41 +0200 received badge  Domanda gettonata (source)
2016-09-17 15:57:51 +0200 ha commentato una risposta Background color based on the background color of another cell?

Yes, the list contains pokemon 001 -> 151. In the Evolution Chart I use 3 columns per evolution (the name of the pokemon (like in the long list), the candy required for evolving into that level & just a column containing "->" merely meaning evolves into). There's max 3 evolution levels.

So it might look like this: 001, 0, ->, 005, 50, ->, 099, 100 002, ,0, -> 098, 25, ->, 045, 45 etc. where the ", " represents a new column

How do I add my file to serve as example how it looks right now????

2016-09-16 14:22:27 +0200 ha commentato una risposta Background color based on the background color of another cell?

There's no specific reason for the use of two sheets. The alphabetical list can very well go below (or above) the Evolution Chart. Maybe that even better for the conditional formatting. Association as in references between the two? No, no association. I'll probably need to add something?

2016-09-16 09:07:17 +0200 ha posto una domanda Background color based on the background color of another cell?

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

PoGo.ods

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