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.
SergeiBaklan
May 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.