hexagon logo

Microsoft Excel question

Hey guys,

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.

Parents
  • 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.

    =AND(LEN(TRIM(F9))>0, OR(F9 > $D9 + $E9 + IF(ISNUMBER(M9),M9,0), F9 < $D9 - ABS($E9)))

Reply
  • 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.

    =AND(LEN(TRIM(F9))>0, OR(F9 > $D9 + $E9 + IF(ISNUMBER(M9),M9,0), F9 < $D9 - ABS($E9)))

Children