In google sheets, how to address the current cell in conditional format custom formula?

By
Short answer:=INDIRECT(ADDRESS(ROW(),COLUMN()))

Example:

If current cell is divisible by 12 apply conditional formatting.
=EQ(MOD(INDIRECT(ADDRESS(ROW(),COLUMN())),12), 0)

Conditional formatting only looks that you return a true or false value E.G. =1 or =true (aka a truth value)

Valid conditional custom formula:

=1

Comments

Post a Comment

Popular posts from this blog

Vim vi how to reload a file your editing

By
5.8. How do I reload/re-edit the current file? You can use the ":edit" command, without specifying a file name, to reload the current file. If you have made modifications to the file, you can use ":edit!" to force the reload of the current file (you will lose your modifications). For more information, read :help :edit :help :edit! :help 'confirm' from - http://vimdoc.sourceforge.net/cgi-bin/vimfaq2html3.pl#5.8
Read more