The help file here
has this to say about the "Formula is" option:
"If you select *Formula is* as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches."
The reality is (I guess) that you can enter any formula, and if it evaluates to a value other than 0, the condition matches.
Now, since a cell reference is also a (very simple formula), you can use the functionality as described, but this is missing the major parts of the functionality.
Apart from this, there should also be information about how relative cell references in the formula are resolved when the condition is applied to a range of cells (I have not been able to find this info anywhere).
Also missing is information about how overlapping conditional formatting is handled.
Steps to Reproduce:
1. Open the help for "Conditional Formatting", look at the "Formula is" line
A sentence which describes a very limited part of the functionality.
Precise information about how formulas in conditional formatting work.
User Profile Reset: No
Can you provide a proposal of how exactly you would correct and add to the text?
Removing meta bug "HelpGaps" as this is not about a new feature.
(In reply to Buovjaga from comment #1)
> Can you provide a proposal of how exactly you would correct and add to the
> Removing meta bug "HelpGaps" as this is not about a new feature.
As a very minimum, I would change it to
"If you select *Formula is* as the condition type, enter a formula. If the formula evaluates to a value other than zero, the condition matches."
Then - possibly with a different wording:
"The formula will be evaluated as if it was entered in the cell, and can use both absolute and relative references. If defining a condition for a range of cells, relative reference should be given relative to the topmost cell in the leftmost column of the range."
This is based on my limited understanding of what the program actually does.
The label "Formula is" should probably be changed to just "Formula".