Clever Geek Handbook

Editing formulas with long conditional formatting in excel

Is there a better way to edit conditional formatting formulas in excel and then use the short and awkward default formula field?

My formula is longer than the box and the left and right arrows automatically change cell references instead of moving the cursor in the box, so I can't see the whole formula I'm trying to edit. Is there a better way to do the editing?

Here's the formula (not really looking for a better formula, just a better way to put it in the formula field for my conditional format rule):

=AND(OR(COUNT($B$5:$B$22)<2, COUNTIF($B$5:$B$22, B3), IF(B4="C",1,0)))
+3


source to share


2 answers


Just press F2 after left clicking in the edit box. This will launch edit mode so you can use the cursor to move forward and backward on the form for editing



+1


source


I had this problem with a slightly shorter formula, and I just selected the formula with the cursor; as you drag, you move through the formula. it worked for me, but I can't remember if the selection process was smooth enough for me to stop in the middle, or if my formula was slightly shorter than the width of the edit pane width, which means slide to the end, let me see the other half. I think I should work for you. you have to edit it somehow



0


source






More articles:


All Articles