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