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

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

Popular posts from this blog

Vim vi how to reload a file your editing