# Why does my conditional formatting not work with this formula?

Below is a formula I want to use in conditional formatting. Its purpose is to blur a range in a text concatenation table if a checkbox B15 is unchecked and if the left and right of the string matches any value from `'Code Sheet'!X4:AD4 (m, ɱ, n, ɳ, ɲ, ŋ, or ɴ)`.

``````=iferror(and(\$B\$15=false,
true,false))),false)
``````

The conditional formatting should blur any combo of the aforementioned values. But my formula does not work outside of a cell. The conditional formatting box turns red without feedback. I have no idea why. Where am I going wrong?

Note: the concatenation table has the range of `C19:CH102`, and the table filters and transposes values - meaning the formula must also adapt to changes in data position.

Use `indirect()` when referring to another sheet in a conditional formatting custom formula rule, like this:
`=not(\$B\$15) * ifna(match(left(C19), indirect("Code Sheet!X4:AD4"), 0)) * ifna(match(right(C19), indirect("Code Sheet!X4:AD4"), 0))`
The formula will only return a truthy value when all three conditions are met. To use an "or" condition that returns a truthy value when any of the conditions is met, replace the `*` with `+`. To always require the first condition, but accept either of the two following conditions, use first `*` `(` second `+` third `)`. See Boolean arithmetic.
• That is correct. Any non-zero number will be considered truthy, i.e., interpreted as `true`, in a conditional formatting custom formula rule. Commented Jan 7, 2023 at 19:08
• Edited the answer. There are currently no values in your sample spreadsheet that would meet the conditions because the checkbox in `B15` is ticked. Untick it to find a cluster of matching cells at `V38:AB44`. Commented Jan 7, 2023 at 19:35