hexagon logo

Excel CONDITIONAL FORMAT editing

Maybe I'm the last to know, but it has been a pain in my rump for quite some time...

EDITING CONDITIONAL FORMATS in Excel.

Need to change something in a cond-format, so you open it, click in the formula bar, but miss by 1 or more spaces, so you hit the arrow key to get to where you need to be but it screws up the entire formula by picking some other cell (in the direction of the arrow you hit). Sucks, right?

Well, simply hit F2 key and the arrows are now arrow movements within the formula. Have to hit F2 each time you click in a new formula bar.
Parents
  • Maybe I'm the last to know, but it has been a pain in my rump for quite some time...

    EDITING CONDITIONAL FORMATS in Excel.

    Need to change something in a cond-format, so you open it, click in the formula bar, but miss by 1 or more spaces, so you hit the arrow key to get to where you need to be but it screws up the entire formula by picking some other cell (in the direction of the arrow you hit). Sucks, right?

    Well, simply hit F2 key and the arrows are now arrow movements within the formula. Have to hit F2 each time you click in a new formula bar.


    Even after knowing about the F2 trick for some time now... I still manage to screw it up. Imagine wanting to go to the beginning of the line in the cell and poof everything ends up a mile away at the beginning of the row instead.
  • Blows my mind how crazy good some of these spreadsheet can get!
Reply Children
No Data