0

Say I'm writing a Conditional Format function, such as this one:

=AND($R1<>"",$S1="",$T1="",$U1="")

I want to add TRIM() to each cell reference, but when I put the cursor at = and then attempt to use the arrow keys to move through the text Excel thinks I'm trying to use the arrow keys to select cells and throws cell references into my formula. Is there a way to have Excel not do this, and just move through the text as normal, so I can edit it as I would in notepad.

Obviously there is a work-around of pasting the formula to notepad and back again, and there may be better ways to look for populated and non populated data.

  • I don't think it's possible to that:( – Máté Juhász May 17 '17 at 6:49
  • 1
    Try manage rules, edit rule and double click in the formula then press F2 and use the arrow normally – Sam May 17 '17 at 9:06
1

As a rule, you can use F2 to get into edit mode in most such boxes, even when you're not explicitly prompted to use it. That includes in Conditional Formatting dialogues, the Name Manager for Named Ranges, entering formulae, etc.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.