Tentacruel Posted May 16, 2015 Report Share Posted May 16, 2015 https://docs.google.com/spreadsheets/d/1nuve0kTeF2p_DjEgBJOuqw3ohV8XpiYCX7BQqr2K_aQ/edit?usp=sharing Check out my sick formatting bruh. Color coding is automatic. Link to comment Share on other sites More sharing options...
mitchermitcher Posted May 16, 2015 Report Share Posted May 16, 2015 >Kingdom Hearts 2 >Vesperia Get to playing, m8 Link to comment Share on other sites More sharing options...
EHN. Posted May 16, 2015 Report Share Posted May 16, 2015 Only a 'good' for hitman absolution? Bruh Link to comment Share on other sites More sharing options...
Nicο Posted May 16, 2015 Report Share Posted May 16, 2015 This is why I keep telling myself I technically don't ever need to buy more games. Link to comment Share on other sites More sharing options...
Lunar Origins Posted May 16, 2015 Report Share Posted May 16, 2015 Add Dark Souls 2 to the list. Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 I don't have even have a steam account and my backlog is bigger... Do I even dare count them all...? Link to comment Share on other sites More sharing options...
Lunar Origins Posted May 16, 2015 Report Share Posted May 16, 2015 Y'all spend too much time gaming Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 Y'all spend too much time gaming On the contrary, we spend too much money gaming. If we spent too much time gaming, we wouldn't have backlogs like these lol Link to comment Share on other sites More sharing options...
Lunar Origins Posted May 16, 2015 Report Share Posted May 16, 2015 I haven't gamed in so long besides League and I'm kind of pissed about that Link to comment Share on other sites More sharing options...
Tentacruel Posted May 16, 2015 Author Report Share Posted May 16, 2015 I don't have even have a steam account and my backlog is bigger... Do I even dare count them all...? I haven't added 3DS and old consoles yet and there's plenty of Steam games I'm just gonna ignore. Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 I haven't added 3DS and old consoles yet and there's plenty of Steam games I'm just gonna ignore. That makes more sense. Color coding is automatic. How do this I'm trying Link to comment Share on other sites More sharing options...
Tentacruel Posted May 16, 2015 Author Report Share Posted May 16, 2015 That makes more sense. How do this I'm tryingIt was a pain in the ass. I'll post the codes when I get home so I don't have to type it on my phone. edit: Okay so... You have to add "conditional formatting" to the top entry of whatever column you're coloring. In my case it's A7, so you set the "range" of conditional formatting to A7:A, this does the whole column automatically. Next you set the rule to whatever condition you want, or in my case, a custom formula. Since I have multiple colors I have multiple condition rules. The first is = (E7 = 1) to check if column E is 1 which means high priority. In lower rows it will automatically use the correct row in E.Add Dark Souls 2 to the list.It's on there l2read. It's just at the top because it's set to high priority. Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 Next you set the rule to whatever condition you want, or in my case, a custom formula. Since I have multiple colors I have multiple condition rules. The first is to check if column E is 1 which means high priority. In lower rows it will automatically use the correct row in E. So what do I put in to get the colors for stuff like Completed, In Progress, etc.? Link to comment Share on other sites More sharing options...
Chiri Tsukikawa Posted May 16, 2015 Report Share Posted May 16, 2015 So what do I put in to get the colors for stuff like Completed, In Progress, etc.? Those are just fill colors. EDIT: Though, there may be a way to automate that, if that's what you meant. If there is, I'm not sure. Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 Those are just fill colors. EDIT: Though, there may be a way to automate that, if that's what you meant. If there is, I'm not sure.Trying to automate it. I understand how to do it numbers-wise, but not text.NEVERMIND "I figured it out." Link to comment Share on other sites More sharing options...
Chiri Tsukikawa Posted May 16, 2015 Report Share Posted May 16, 2015 NEVERMIND "I figured it out." But it can't be done. Link to comment Share on other sites More sharing options...
Agro Posted May 16, 2015 Report Share Posted May 16, 2015 But it can't be done.I just had to do what I did with the numbers but put quotations around the text instead. Link to comment Share on other sites More sharing options...
Chiri Tsukikawa Posted May 16, 2015 Report Share Posted May 16, 2015 I see. Link to comment Share on other sites More sharing options...
Tentacruel Posted May 16, 2015 Author Report Share Posted May 16, 2015 I just had to do what I did with the numbers but put quotations around the text instead. Yeah that's how it works, I forgot to tell you that. Link to comment Share on other sites More sharing options...
Agro Posted May 17, 2015 Report Share Posted May 17, 2015 Yeah that's how it works, I forgot to tell you that. Lol. Don't go into education. Tenta: "Alright class, and that's how you do basic math." 1st Grader: "Mr. Tenta, but what does the 'x' symbol mean?" Tenta: "Figure it out, bitch." Link to comment Share on other sites More sharing options...
Agro Posted May 18, 2015 Report Share Posted May 18, 2015 https://docs.google.com/spreadsheets/d/1It1AeNqJl836Y_bzan1IrQd3tJiGA-uBU0T7WHb6KQU/edit?usp=sharing How's mine? Link to comment Share on other sites More sharing options...
Tentacruel Posted May 18, 2015 Author Report Share Posted May 18, 2015 https://docs.google.com/spreadsheets/d/1It1AeNqJl836Y_bzan1IrQd3tJiGA-uBU0T7WHb6KQU/edit?usp=sharing How's mine? so many games I like the "played" section. Maybe in the future I'll make a document with all of my games and not just my current "to play" stuff. Link to comment Share on other sites More sharing options...
Agro Posted May 18, 2015 Report Share Posted May 18, 2015 so many games I like the "played" section. Maybe in the future I'll make a document with all of my games and not just my current "to play" stuff. I figured I should have a section for games I can't really complete, but that I've played enough of to experience. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.