Skip to content

Instantly share code, notes, and snippets.

@ThomasHineXYZ
Last active February 22, 2021 02:58
Show Gist options
  • Save ThomasHineXYZ/3590771aa77df11cc97ff619514812fb to your computer and use it in GitHub Desktop.
Save ThomasHineXYZ/3590771aa77df11cc97ff619514812fb to your computer and use it in GitHub Desktop.
Pokemon Nature highlighting for spreadsheet software
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