Microsoft Excel question

There are SO many things I absolutely hate about Excel from the moment they went with the ribbon. WAY back when they did that, the IT here wanted to upgrade me to that version of Excel. I said, yeah, put it on there BUT DO NOT destroy any of my current version of office until I find out if they mucked it up. Yup, they mucked it up. Been YEARS, but I do know that they removed a function in Excel that I used (been too long to remember, but I remember that they removed one) so I could not set it up and use it, it would use it as 'legacy' but I was no longer to 'build' with it. ANYWAY, in Excel 2003, the conditional formatting is SO MUCH easier. I duplicated A9-K29 of your form. It appears that you want the cell color to turn RED if out of tolerance.

SO, I select F8 thru K8 and put in the conditional format to make the cell turn red if the value isn't between the tol limits. Looks like this:


As you can see, it has the $ in the cell values, this is the 'default' way Excel works. In order to COPY that to other rows and have the cond-format update, I have to remove the $ from EACH cell cond-format individually thusly:


Once all 6 cells have had the cond-format edited, I can then copy the 6 cells down and the results look like this:



AND, you can change the tolerances shown in the file (happens all the time in sheet metal work) and there is no need to futz with the cond-formatting.

There are SO many things I absolutely hate about Excel from the moment they went with the ribbon. WAY back when they did that, the IT here wanted to upgrade me to that version of Excel. I said, yeah, put it on there BUT DO NOT destroy any of my current version of office until I find out if they mucked it up. Yup, they mucked it up. Been YEARS, but I do know that they removed a function in Excel that I used (been too long to remember, but I remember that they removed one) so I could not set it up and use it, it would use it as 'legacy' but I was no longer to 'build' with it. ANYWAY, in Excel 2003, the conditional formatting is SO MUCH easier. I duplicated A9-K29 of your form. It appears that you want the cell color to turn RED if out of tolerance.

SO, I select F8 thru K8 and put in the conditional format to make the cell turn red if the value isn't between the tol limits. Looks like this:


As you can see, it has the $ in the cell values, this is the 'default' way Excel works. In order to COPY that to other rows and have the cond-format update, I have to remove the $ from EACH cell cond-format individually thusly:


Once all 6 cells have had the cond-format edited, I can then copy the 6 cells down and the results look like this:



AND, you can change the tolerances shown in the file (happens all the time in sheet metal work) and there is no need to futz with the cond-formatting.