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.

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.

you have no idea how complex it is. The master (blank) file that I use to make reports for everything we check is 67mb in size.

It can:
(1) Show a roadmap of all features (feature ID's)
(2) Average results from up to a 30-pc study
(3) Show any single part from the study
(4) Show ranges from the study
(5) Show the tolerance for each feature
All in the same cell on the report, all you have to do is change the value of 1 cell for what you want displayed and it all changes.

It will also ONLY show OOT features (single cell data entry)
It will let you show only SPC, or SURFACE, or TRIM, or HOLES or SINGLE AXIS (flatness and the like) features with a single cell data entry.

You can toggle on/off body axis deviation letters

You can have it show deviations for hole sizes or actual hole sizes

And, of course, all the COND-FORMAT that change background, border, and all that.

And all that is just for the "pretty picture" page. There are also raw data pages as well as a LEGACY look-alike report page.

you have no idea how complex it is. The master (blank) file that I use to make reports for everything we check is 67mb in size.

It can:
(1) Show a roadmap of all features (feature ID's)
(2) Average results from up to a 30-pc study
(3) Show any single part from the study
(4) Show ranges from the study
(5) Show the tolerance for each feature
All in the same cell on the report, all you have to do is change the value of 1 cell for what you want displayed and it all changes.

It will also ONLY show OOT features (single cell data entry)
It will let you show only SPC, or SURFACE, or TRIM, or HOLES or SINGLE AXIS (flatness and the like) features with a single cell data entry.

You can toggle on/off body axis deviation letters

You can have it show deviations for hole sizes or actual hole sizes

And, of course, all the COND-FORMAT that change background, border, and all that.

And all that is just for the "pretty picture" page. There are also raw data pages as well as a LEGACY look-alike report page.