Posts

Showing posts from July, 2018

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