How to navigate long formulas with the keyboard?

Solution 1:

To move through the formula using the keyboard, select anywhere in the formula and hit the F2 key.

This is the same functionality as when editing a formula in a cell. If you just use the arrow keys, it will select cells for use in the formula. If you are selected in a formula and hit F2, it will switch so that the arrow keys move the cursor through the formula.

After hitting F2, holding down the shift and control keys also offers similar functionality for snapping to the end of a word and highlighting text.

Solution 2:

You need two conditions:

The first one (for green) uses the following formula:

=AND(F14<>"",F14=C14)

And the second one (for red) uses:

=AND(F14<>"",F14<>C14)