Last active
February 22, 2021 02:58
-
-
Save ThomasHineXYZ/3590771aa77df11cc97ff619514812fb to your computer and use it in GitHub Desktop.
Pokemon Nature highlighting for spreadsheet software
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Column M is the column named Nature for me, but you do have to leave it as 1 for that column. | |
Stat: | |
Increase | |
Decrease | |
Attack: | |
=IF(OR(INDEX(COUNTIF(M1,{"Lonely"; "Brave"; "Adamant"; "Naughty"}),)), TRUE, FALSE) | |
=IF(OR(INDEX(COUNTIF(M1,{"Bold"; "Timid"; "Modest"; "Calm"}),)), TRUE, FALSE) | |
Defense: | |
=IF(OR(INDEX(COUNTIF(M1,{"Bold"; "Relaxed"; "Impish"; "Lax"}),)), TRUE, FALSE) | |
=IF(OR(INDEX(COUNTIF(M1,{"Lonely"; "Hasty"; "Mild"; "Gentle"}),)), TRUE, FALSE) | |
Sp. Attack: | |
=IF(OR(INDEX(COUNTIF(M1,{"Modest"; "Mild"; "Quiet"; "Rash"}),)), TRUE, FALSE) | |
=IF(OR(INDEX(COUNTIF(M1,{"Adamant"; "Impish"; "Jolly"; "Careful"}),)), TRUE, FALSE) | |
Sp. Defense: | |
=IF(OR(INDEX(COUNTIF(M1,{"Calm"; "Gentle"; "Sassy"; "Careful"}),)), TRUE, FALSE) | |
=IF(OR(INDEX(COUNTIF(M1,{"Naughty"; "Lax"; "Naive"; "Rash"}),)), TRUE, FALSE) | |
Speed: | |
=IF(OR(INDEX(COUNTIF(M1,{"Timid"; "Hasty"; "Jolly"; "Naive"}),)), TRUE, FALSE) | |
=IF(OR(INDEX(COUNTIF(M1,{"Brave"; "Relaxed"; "Quiet"; "Sassy"}),)), TRUE, FALSE) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment