I can't seem to find the solution I'm looking for. Is there a way to copy and paste conditional formatting without having to make a new rule for every line? I am looking to apply a < = / > = into my reports and im wondering if you guys have an easy way to do this. The way I'm doing it I have to make a new rule for every line and there has to be a better way... I didn't write this program but my understanding is, if you dimension everything that has the same tolerance it's much easier to do it in chunks. I appreciate any feedback.
I do struggle with Excel. Even if I do it one cell at a time it continues to put the $$ back. I will continue to try your suggestion! Frustrating but I will figure this out
Am I to edit in this window ?
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.
Matthew D. Hoedeman Thanks so much Matthew! I appreciate you taking the time to make that and explain it to me. I will try this as soon as I get time. Again, Thank you.
Here is the formula that you want. Use a formula to determine which cells to format. The bolded section will include bonus tolerance if you have it on your report so you will have to change the M9 to the cell that contains the bonus tolerance. This will format any cell out of spec to the color you have selected in the format box. no need to have multiple formats applied to the report. Get the first cell set up and the just format paint everything else.