Individual worksheet contain current run test results(sheets are named using a SN). These named cells are in a different worksheet than conditional formatting target worksheets (28 of these, 1/SN). I named the ranges (single cells) as SN_TPx (x, being 1, 2, 3.6). I am trying to 'grab' a value for each part and parameter to be used in conditional formatting formula: '=rnSource +/- (rnSource*Tolerance)'.Įach part number has a SN and 6 test point results (TPs). There are 28 parts with 6 performance criteria each. I am building a workbook that contains test results for control parts that company I work for manufactures.
my queries return mostly 'how to name a range using VBA in Excel'. Also I likely can't find the solution as I don't know the language, thus my questions are not meaningful/on the mark. I have about 10 days of VBA Excel experience so please excuse my mistakes/ignorance.