hexagon logo
Register Sign in
  • Replies 7 replies
  • Subscribers 22 subscribers
  • Views 203 views
  • Users 0 members are here
Options
Related

Excel CONDITIONAL FORMAT editing

Matthew D. Hoedeman
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.
  • in reply to Kp61dude!
    I don't need to imagine it, I've dealt with it. I have over 2,000 cells in an Excel file that I am adding an additional format possibility to the 3rd conditional format. Condition 1 looks at the value of a specific cell, if it is equal to 1, it puts a red border around the cell (OUT of tol). Condition 2 is for the range of the study, too much range, it highlights the cell dull-yellow. Condition #3 is for hiding the cell (no border, no background, white text). This has been for selecting only 1 type of feature to be displayed, but I need to add to it that if the feature is IN tolerance and the SHOW ONLY OOT is turned on, it will also be blank. Thanks to the F2 ability and my programmable keypad, it is a SINGLE KEY STROKE on the keypad to do all of that.
Reply
  • in reply to Kp61dude!
    I don't need to imagine it, I've dealt with it. I have over 2,000 cells in an Excel file that I am adding an additional format possibility to the 3rd conditional format. Condition 1 looks at the value of a specific cell, if it is equal to 1, it puts a red border around the cell (OUT of tol). Condition 2 is for the range of the study, too much range, it highlights the cell dull-yellow. Condition #3 is for hiding the cell (no border, no background, white text). This has been for selecting only 1 type of feature to be displayed, but I need to add to it that if the feature is IN tolerance and the SHOW ONLY OOT is turned on, it will also be blank. Thanks to the F2 ability and my programmable keypad, it is a SINGLE KEY STROKE on the keypad to do all of that.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement