Forum Discussion
J2-____jj
May 10, 2019Copper Contributor
Using formula function instead of conditional formatting
Can a conditional format be replaced with a if, then function containing cell formatting functions? If so, where can I get information and examples?
PeterBartholomew1
May 11, 2019Silver Contributor
You can develop your formulas and then assign then to a defined Name using Name Manager. The formula should result in TRUE or FALSE when evaluated in each of the conditionally formatted cells. Each conditional will depend on one such formula.
- SergeiBaklanMay 11, 2019Diamond Contributor
PeterBartholomew1 more exactly TRUE (or its numeric equivalent) or whatever else, even error.
- PeterBartholomew1May 11, 2019Silver Contributor
Agreed
TRUE can also be any non-zero number
FALSE can also be a character string, zero, an error or a blank cell
Have I missed anything?
The thing that causes me most grief is the inability of CF to work with a Boolean array; all it seems to see is the value of the first item. It also fails on Range intersection but at least that can be hidden within a defined name.