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
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