Skip to content

Instantly share code, notes, and snippets.

@thiagoeh

thiagoeh/excel.md

Created May 2, 2018 19:15
Show Gist options
  • Save thiagoeh/e0d8b36d1cd88be7f905e745bd512b26 to your computer and use it in GitHub Desktop.
Save thiagoeh/e0d8b36d1cd88be7f905e745bd512b26 to your computer and use it in GitHub Desktop.
Download ZIP
Excel boolean based on cell color formatting
Raw
excel.md 
=AND(NOT(GET.CELL(63;INDIRECT("RC[-1]";FALSE)));INDIRECT("RC[-1]";FALSE)<>1;INDIRECT("RC[-1]";FALSE)<>7)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment