hexagon logo
Register Sign in
  • Replies 7 replies
  • Subscribers 22 subscribers
  • Views 197 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!
    Yes, I use Google Sheets for my home budgeting and every sheet makes use of the "INDIRECT" function, handy. Another one that I've started using a bunch is "QUERY" function (though not sure if Excel has that built in, I'm sure they do) https://support.google.com/docs/answer/3093343?hl=en.

    For work I've broken away from QC and therefore don't really touch Excel anymore but have devised other methods of crunching mass amounts of data like databases and C++/C# applications to then be available over the company web for anyone and everyone interested in numbers. I still use the good ol' Legacy text standard CMM report for QC department.
Reply
  • in reply to Kp61dude!
    Yes, I use Google Sheets for my home budgeting and every sheet makes use of the "INDIRECT" function, handy. Another one that I've started using a bunch is "QUERY" function (though not sure if Excel has that built in, I'm sure they do) https://support.google.com/docs/answer/3093343?hl=en.

    For work I've broken away from QC and therefore don't really touch Excel anymore but have devised other methods of crunching mass amounts of data like databases and C++/C# applications to then be available over the company web for anyone and everyone interested in numbers. I still use the good ol' Legacy text standard CMM report for QC department.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement